|
» Saving Filtering Criteria
CATEGORY: Excel Filter |
VERSIONS: All Microsoft Excel Versions |
|
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 |
  |
|
RATING:
3.18
VIEWS: 32580 |
||||
Auto Filter Savings
mamritshah wrote on December 31, 1969 18:00 EST
THis tip is helpful for havings views of all filters at one click
Sponsors:
 |
Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Business Plans Kit for Dummies (With CD-ROM)
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
Related MS EXCEL TIPS:
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.
