» Saving Filtering Criteria
CATEGORY - Excel Filter
VERSION - All Microsoft Excel Versions
Step 1: Add the Custom Views icon to the toolbar
1. Place the mouse over one of the toolbars, right click, and select Customize from the shortcut menu.
2. Select the Commands tab.
3. From Categories, select View and drag the Custom Views icon to the Menu bar.
Step 2: Save the filtering criteria
1. Select a cell from the column containing the criteria you want to Filter with.
2. Click the AutoFilter icon (see Tip #261).
3. Type any text criteria you want into the Custom Views box and click twice to save.
4. Repeat the previous step and save as many filtering criteria as needed from any sheet within the workbook.
Note:
Save as many filtering criteria in Custom Views as needed.

Book Store:
Recommended Books:
- Financial Reporting and Analysis (2nd Edition)
- Accounting Principles, with CD, 6th Edition
- A Mathematician Plays the Stock Market
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
Auto Filter Savings
mamritshah
THis tip is helpful for havings views of all filters at one click

