Datasheet

simply adding, counting, or averaging the values in a table gives extremely
useful insights.
Sorting table records
After you place information in an Excel table, you’ll find it very easy to sort
the records. You can use the Sort A to Z button, the Sort Z to A button, or the
Sort dialog box.
Using the Sort buttons
To sort table information by using a Sort buttons, click in the column you
want to use for your sorting. For example, to sort a grocery list like the one
shown in Figure 1-8 by the store, click a cell in the Store column.
After you select the column you want to use for your sorting, click the Sort A
to Z button to sort table records in ascending, A-to-Z order using the selected
column’s information. Alternatively, click the Sort Z to A button to sort table
records in descending, Z-to-A order using the selected column’s information.
Using the Sort dialog box
When you can’t sort table information exactly the way you want by using the
Sort A to Z and Sort Z to A buttons, use the Sort dialog box.
To use the Sort dialog box, follow these steps:
1. Click a cell inside the table.
2. Choose the Data➪Sort command.
Excel displays the Sort dialog box, as shown in Figure 1-9.
Figure 1-9:
Set sort
parameters
here.
19
Chapter 1: Introducing Excel Tables
05_045992 ch01.qxp 1/18/07 5:45 PM Page 19