Excel 2010 Bible

Chapter 5: Introducing Tables

111

And within each area, sort the rows 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 5.10 shows the

table sorted in this manner.

Note
When a column is sorted, the drop-down list in the header row displays a different graphic to remind you that
the table is sorted by that column. n

FIGURE 5.10

A table, after performing a three-column sort.

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 Sort ➪

Custom Sort from the shortcut menu.

In the Sort dialog box, use the drop-down lists to specify the sort specifications. 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 column. Then, add another level

and enter the specifications for the List Price column. Figure 5.11 shows the dialog box after enter-

ing the specifications for the three-column sort. This technique produces exactly the same sort as

described in the previous paragraph.