EXCEL 快速筛选
2018-09-23 12:10 更新
中国教程网zhangditony翻译，转载请保留此信息 .
To quickly filter a List, add the AutoFilter and Show All icons to the Standard toolbar
为实现快速筛选，增添“自动筛选”和“全部显示”按钮到常用工具栏。
1. Place the mouse arrow on one of the toolbars, right-click, and select Customize from the shortcut menu.
2. In the Customize dialog box, select the Commands tab.
3. From Categories, select Data, and from the Commands box, drag the AutoFilter and Show All icons to the Standard toolbar.
4. Click Close
为实现快速筛选，增添“自动筛选”和“全部显示”按钮到常用工具栏。
1. Place the mouse arrow on one of the toolbars, right-click, and select Customize from the shortcut menu.
2. In the Customize dialog box, select the Commands tab.
3. From Categories, select Data, and from the Commands box, drag the AutoFilter and Show All icons to the Standard toolbar.
4. Click Close
![20070717_e8c6b22b3ca58a3c614dock6ylvwfmgu[1].gif](https://atts.w3cschool.cn/attachments/image/20151103/1446546826775151.gif "1446546826775151.gif")
以上内容是否对您有帮助：
更多建议：