During the sorting process, Excel will compare the top rows of your worksheet for formatting differences. If the top row is formatted differently from the subsequent rows, then Microsoft Excel will identify it as a column label and will exclude it from the sort.

To perform a multiple-level sort, follow the instructions below.

1. Open the spreadsheet that contains the data you wish to sort.
2. Click once within the data.
3. Click on the word Data in the Menu bar.
4. Select the option Sort.
5. The Sort dialog will appear.

   

6. Use the Sort by and Then by fields to perform a multiple-level sort.
7. Click on the OK button.
8. Your data will be sorted accordingly.

Note: To sort days or months in chronological order, click on the Options button in the lower right-hand corner of the Sort dialog. The Sort Options dialog will appear, providing you with more sorting options.

Click HERE to return to the Table of Contents.