6 of 12 in Series:
The Essentials of Creating and Working with Tables in Excel 2007
>
Use the AutoFilter feature in Excel 2007 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.
>
>
>
1
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.
>
>
>
>
2
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.
>
>
>
>
3
Remove the check mark from Select All.
>
All items in the list are deselected.
>
>
>
>
4
Select the check box for the entry you want to filter on 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.
>
>
>
>
5
(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.
>
>
To remove filters and redisplay all table data, click the Clear button on the Data tab. If multiple columns are filtered, you can click a filter arrow and select Clear Filter to remove a filter from that column only. To remove the filter arrows when you’re done filtering data, choose Filter in the Sort & Filter group of the Data tab (or press Ctrl+Shift+L).
>
dummies
Source:http://www.dummies.com/how-to/content/filtering-records-in-an-excel-2007-table-with-auto.html
No comments:
Post a Comment