Excel Filter
 |
 |
 |
 |
 |
 |
 |
Excel Filter
Additional Resources
Excel Filter
Excel Filter | Microsoft Excel XP | Page 2 |
 |
You can stare at you data for hours on end and still gain nothing for your time.
Spreadsheet data is often not much good unless you can analyze it. If you're familiar with some of the actions that you can perform on a database, managing and analyzing your data in Excel is within your grasp.
And even if you've never even heard of a database, you can still filter lists to your heart's content.
 |
What's on this page... Using AutoFilter Using Custom AutoFilter Using Advanced Filter Using criteria for text Using criteria for values |
Using Custom AutoFilter
Normally, AutoFilter involves selecting a single value for one or more columns and then use the Excel filter.The list is then filtered by that value. For more flexibility, choose the Custom option in an AutoFilter drop-down list.
The Custom AutoFilter dialog box let's you filter in several ways:
| ► |
VALUES ABOVE OR BELOW A SPECIFIED VALUE For example, sales amount greater than 10,000. |
| ► |
VALUES WITHIN A RANGE For example, sales amounts greater than 10,000 AND sales amounts less than 50,000. |
| ► |
VALUES OUTSIDE OF A RANGE For example, sales amounts less than 10,000 OR sales amounts greater than 50,000. |
| ► |
TWO
DISCRETE VALUES For example, state equal to New York OR state equal to New Jersey. |
| ► |
APPROXIMATE MATCHES You can use the * and ? wildcards to filter in many other ways. For example, to display only those customers whose last name begins with a B, use B*. |
Custom AutoFilter is useful, but it has limitations.
For example, if you would like to filter the list to show only three values in a field (such as New York or New Jersey or Connecticut), you can't do it by using AutoFilter.
Such filtering tasks require the advanced filtering feature.
| Back to Top |
| See also... Using AutoFilter | Using Advanced Filter |
| Using Criteria for Text | Using Criteria for Values |
| Return to Excel XP from Excel Filter |
Excel XP Topics
- Tips- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter