Sorting the Data

One of the easiest ways to organize or evaluate your data is to use Excel’s Sort feature. There are a couple of ways to control the sort—you can do a simple ascending or descending sort, or you can specify which data you want to sort and the type of sort you want to conduct.

Conduct an Alphabetic or a Numeric Sort

  1. Select the columns or the portions of columns whose contents you want to sort.

  2. On the Data tab, click the Sort button to display the Sort dialog box.

  3. Specify whether or not the columns have header labels.

  4. Specify which column ...

Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.