Microsoft Office Tutorials and References
In Depth Information
When a column is sorted, the drop-down control in the Header row displays a different
graphic to remind you that the table is sorted by that column. If you sort by several
columns, only the column most recently sorted displays the sort graphic.
You can sort on any number of columns. The trick is to sort the least significant column first and then proceed
until the most significant column is sorted last.
For example, in the real estate listing table (refer to Figure 9-6), you may want the list to be sorted by agent.
And within each agent's group, the rows should be sorted by area. And within each area, the rows should be sor-
ted (descending) by list price. For this type of sort, first sort by the List Price column, then sort by the Area
column, and then sort by the Agent column. Figure 9-7 shows the table sorted in this manner.
Figure 9-7: A table, after performing a three-column sort.
Another way of performing a multiple-column sort is to use the Sort dialog box. To display this dialog box,
choose Home ⇒ Editing ⇒ Sort & Filter ⇒ Custom Sort. Or, right-click any cell in the table and choose Sort ⇒ Cus-
tom Sort from the shortcut menu.
In the Sort dialog box, use the drop-down lists to specify the first search specifications. Note that the searching
is opposite of what I described earlier. 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 specifications for the Area