EXCEL 快速篩選

 

To quickly filter a List, add the AutoFilter and Show All icons to the Standard toolbar
為實(shí)現(xiàn)快速篩選，增添“自動(dòng)篩選”和“全部顯示”按鈕到常用工具欄。
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