Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Saving Filtering Criteria

CATEGORY: Excel Filter
To save filtering criteria, use Custom Views:

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.
Screenshot // Saving Filtering Criteria

Saving Filtering Criteria
Rate this tip
12 34 5
  RATING: 3.22
  VIEWS: 35094
Auto Filter Savings
mamritshah wrote on December 31, 1969 19:00 EST
THis tip is helpful for havings views of all filters at one click



REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation