Page 130 - Ms Excel Note and Workbook
P. 130
MICROSOFT EXCEL NOTE AND WORKBOOK
Sorting Levels
If you need more control over how your data is sorted, you can add multiple levels to any sort. This
allows you to sort your data by more than one column.
To add a level:
In our example below, we'll sort the worksheet by T-Shirt Size (Column D), and then by Homeroom
Number (column A).
1. Select a cell in the column you want to sort by. In our example, we'll select cell A2.
2. Click the Data tab, then select the Sort command.
3. The Sort dialog box will appear. Select the first column you want to sort by. In this
example, we will sort by T-Shirt Size (column D) with the custom list we previously
created for the Order field
121 | P a g e
