Sorting Data in a List
Sorting data allows you to see all related data in successive rows, which is both useful in and of itself and is necessary if you wish to add subtotals to your data. To sort data in a list in Microsoft Excel:
- Select any cell within the list you wish to sort.
- On the DATA tab, in the Sort & Filter group, click the Sort command:
- In the Sort dialog box:
- Verify that My data has headers is checked if your list has a header row and not checked if it doesn't.
- Choose what column to sort by.
- Choose what to sort on. The default is to sort on Values, but you can also choose to sort on Cell Color, Font Color, and Cell Icon.
- Choose whether to sort ascending or descending.
- You can also:
- Add a level, meaning sort by one thing and then again by a second thing (click Add Level). Clicking Add Level adds a second set of Column, Sort On, and Order boxes to the Sort dialog box.
- Sort left to right instead of top to bottom (click on Options).
- Click OK.