Microsoft® Office Excel® 2003 Step by Step

Chapter 7 Reordering and Summarizing Data

Sorting a Data List To sort a data list

1. Select the column of cells to be sorted.

2. On the Standard toolbar, click the Sort Ascending or Sort Descending button.

Sorting a Data List To sort a data list by multiple columns

1. Select the columns of cells to be sorted.

2. On the Data menu, click Sort.

3. If necessary, click the Sort by down arrow, and then, from the list that appears, click the first column to sort by.

4. Click the Then by down arrow, and then, from the list that appears, click the next column to sort by.

5. Repeat step 4 with the next Then by down arrow.

6. Click OK.

Sorting a Data List To set a custom sort order

1. Type a custom list and highlight its cells.

2. On the Tools menu, click Options.

3. Click the Custom Lists tab.

4. Click ...