Special Edition Using Microsoft® Office XP

Finding and Filtering Data in a List

When working with lists, you can use the Find shortcut (Ctrl+F) to search for any value in the list. That technique is useful if you want to jump quickly to a specific unique value in the list. More often, however, you'll want to extract details from a list instead of simply jumping to a single record. In that case, use filters to hide all records except those that match criteria that you specify. In a list that contains hundreds or thousands of rows, defining a filter helps you see a small number of related records together, making it easier to compare data and identify trends.

For example, in a list of daily high, low, and closing stock prices that includes data for many companies, you might want to see ...