Datasheet

For a start, the Sort Options dialog box enables you to indicate whether
case sensitivity (uppercase versus lowercase) should be considered.
You can also use the Sort Options dialog box to tell Excel that it should
sort rows instead of columns or columns instead of rows. You make this
specification by using either Orientation radio button: Sort Top to
Bottom or Sort Left to Right. Click OK when you’ve sorted out your
sorting options.
6. Click OK.
Excel then sorts your list.
Using AutoFilter on a table
Excel provides an AutoFilter command that’s pretty cool. When you use
AutoFilter, you produce a new table that includes a subset of the records
from your original table. For example, in the case of a grocery list table, you
could use AutoFilter to create a subset that shows only those items that
you’ll purchase at Butchermans or a subset table that shows only those
items that cost more than, say, $2.
To use AutoFilter on a table, take these steps:
1. Select your table.
Select your table by clicking one of its cells. By the way, if you haven’t
yet turned the worksheet range holding the table data into an “official”
Excel table, select the table and then choose the Insert➪Table command.
2. (Perhaps unnecessary) Choose the AutoFilter command.
When you tell Excel that a particular worksheet range represents a table,
Excel turns the header row, or row of field names, into drop-down lists.
Figure 1-11 shows this. If your table doesn’t include these drop-down
lists, add them by choosing Data➪Filter. Excel turns the header row, or
row of field names, into drop-down lists.
3. Use the drop-down lists to filter the list.
Each of the drop-down lists that now make up the header row can be
used to filter the list.
21
Chapter 1: Introducing Excel Tables
05_045992 ch01.qxp 1/18/07 5:45 PM Page 21