Microsoft Office Tutorials and References
In Depth Information
Sorting and filtering a table
sort, fi rst sort by the List Price column, then sort by the Area column, and then sort by the
Agent column. Figure 19.8 shows the table sorted in this manner.
A table, after performing a three-column sort
When a column is sorted, the Filter button in the header row displays a different graphic to remind you that the table
is sorted by that column.
Another way of performing a multiple-column sort is to use the Sort dialog box (choose
Home Editing Sort & Filter Custom Sort). Or right-click any cell in the table and choose
Custom Sort from the shortcut menu.
In the Sort dialog box, use the drop-down lists to specify the sort specifi cations. In this
example, you start with Agent. Then click the Add Level button to insert another set of
search controls. In this new set of controls, specify the sort specifi cations for the Area
column. Then add another level and enter the specifi cations for the List Price column. Click
OK to apply the sort. This technique produces exactly the same sort as described in the
previous paragraph.
Filtering a table
Filtering a table refers to displaying only the rows that meet certain conditions. The other
rows are hidden. Note that the entire rows are hidden. Therefore, if you have other data
to the left or right of your table, that information will also be hidden. If you plan to fi filter
your list, don’t include any other data to the left or right of your table.
Using the example real estate table we’ve been discussing, assume that you’re only
interested in the data for the N. County area. Click the Filter Button in the Area Row
Search JabSto ::

Custom Search