EXCEL 快速筛选

 

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