|
» 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.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
Sponsors:
 |
Book Store:
Recommended Books:
- Financial Risk Manager Handbook, Second Edition
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Analysis of Financial Statements
- PowerPoint® 2002 For Dummies®
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.
