| If you have a list of either text or numbers, you might want to reorder the list for a different purpose. Excel lets you sort your data by any column, in either ascending or descending order. To sort a range of cells, follow these steps: 1. | Select all the cells you want to sort. | 2. | Select Data, Sort to display the Sort dialog box, shown in Figure 14.4. Figure 14.4. Sort your list by any column, in any order.
| 3. | Select whether your list does or doesn't have a header row. | 4. | Pull down the first Sort By list, and select which column you want to sort by. | 5. | Choose to sort in either Ascending or Descending order. | 6. | Repeat steps 4 and 5 to sub-sort on additional columns, using the Then By lists. | 7. | Click the OK button to sort the data. |
|