Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Use the AutoFilter feature in Excel 2010 to hide everything in a table except the records you want to view. Filtering displays a subset of a table, providing you with an easy way to break down your data into smaller, more manageable chunks. Filtering does not rearrange your data; it simply temporarily hides rows that don't match the criteria you specify.

Click inside a table, and then choose Filter in the Sort & Filter group of the Data tab (or press Ctrl+Shift+L).

Filter arrows appear beside the column headings. If the data is formatted as an Excel table, skip this step; you should already see the filter arrows.

Click the filter arrow beside the column heading for the column you want to filter.

Click the filter arrow beside the column heading for the column you want to filter.

Excel displays a drop-down list, which includes one of each unique entry from the selected column.

Remove the check mark from Select All.

All items in the list are deselected.

Select the check box for the entry you want to filter and then click OK.

Select the check box for the entry you want to filter and then click OK.

You can select multiple check boxes to filter on two or more items. Excel displays only the records that match your selections.

(Optional) Repeat Steps 2–4 as needed to apply additional filters to other columns in the filtered data.

You can apply filters to multiple columns in a table to further isolate specific items. Notice that the filter arrows on filtered columns take on a different appearance to indicate that a filter is in use.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: