Displaying Parts of a List with AutoFilter

graphics/microsoft40.gif

Working with a list that contains numerous records can be difficult ”unless you can narrow your view of the list when necessary. For example, rather than looking through an entire inventory list, you might want to see records that come from one distributor. The AutoFilter feature creates a list of the items found in each field. You select the items that you want to display in the column (that is, the records that meet certain criteria). Then you can work with a limited number of records.

Display Specific Records Using AutoFilter

graphics/one_icon.jpg

Click anywhere within the list range.

graphics/tow_icon.jpg

Click the Data menu, point to Filter, and then click AutoFilter.

graphics/three_icon.jpg

Click the list arrow of the field for which you want to specify search criteria.

graphics/foure_icon.jpg

Select the item that records must match in order to be included in the list.

graphics/five_icon.jpg

Repeat steps 3 and 4, as necessary, to filter out more records using additional fields.

graphics/six_icon.jpg

Click the Data menu, point to Filter, and then click AutoFilter to turn off AutoFilter and redisplay all records in the list.

graphics/10inf15.jpg

graphics/10inf16.jpg

graphics/10inf17.jpg

Did You Know?

You can speed up your work with the Top 10 list . AutoFilter offers a Top 10 command in the list of every field. Click this command to quickly create a filter for the top or bottom 10 items in a list.



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net