Microsoft Office Tutorials and References
In Depth Information
A particularly useful feature, filtering, enables you to display only the records that you want to
see. When Filter mode is on, you can filter the data by selecting values from pull-down menus
(which appear below the field names when you choose the Data
Rows that don’t meet the filter criteria are hidden. See Figure 1-12 for an example.
Sort & Filter
If you convert a worksheet database into a table (by using Insert
Table), filtering is
turned on automatically.
Figure 1-12: Excel’s Filter feature makes it easy to view only the database records that meet your criteria.
If you prefer, you can use the traditional spreadsheet database techniques that involve criteria
ranges. To do so, choose the Data
Sort & Filter
Chapter 9 provides additional details regarding worksheet lists and databases.
Excel can automatically insert (or remove) subtotal formulas in a table that is set up as a
database. It also creates an outline from the data so that you can view only the subtotals or any level
of detail that you desire.
A worksheet outline is often useful when working with hierarchical data, such as budgets. Excel
can create an outline automatically by examining the formulas in your worksheet (use the
Subtotal command). After you’ve created an outline, you can collapse or expand
the outline to display various levels of details. Figure 1-13 shows an example of a worksheet outline.