Microsoft Office Tutorials and References
In Depth Information
Sorting a Range, Region, or Table
To sort by multiple columns, click Sort on the Data tab; or click Sort & Filter on the Home
Tab and then click Custom Sort; or right-click a cell in the table or range, click Sort, and
then click Custom Sort.
Any of those roads take you to the Sort dialog box, shown in Figure 12-6. In operation, it’s
pretty straightforward and easy to figure out. You build a list of sort levels, each based on a
column, and then define the sort order for each level.
Figure 12-6 Create as many custom Sort By conditions as you need to arrange your list. Use the
up and down arrow buttons to change their order.