O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required