Datasheet

590
Sorting Data
10. Click the Format as Table command button on the Home tab (or press
Alt+HT) and then click a table style from the Light, Medium, or Dark
section of its gallery.
Excel opens the Format As Table dialog box and places a marquee
around all the cells in the data list.
11. Make sure that the My Table Has Headers check box has a check mark
in it and that all the cells in the data list are included in the cell range
displayed in the Where Is the Data for Your Table text box before you
click OK.
Figure 1-12 shows the personnel data list after sorting its fields according
to the values in the first row. After sorting the data list, you then delete this
row and modify the widths of the columns to suit the new arrangement and
reformat the list as a table before you save the worksheet.
When sorting the columns in a data list, you must remember to click
the Options button and click the Sort Left to Right option button in the
Orientation section of the Sort Options dialog box. Otherwise, Excel sorts
your records instead of your columns, and in the process, the row of field
names becomes sorted in with the other data records in your list!
Figure 1-12:
Personnel
data list
after sorting
the columns
using the
values
entered in
the first row.
30_489598-bk06ch01.indd 59030_489598-bk06ch01.indd 590 3/27/10 12:46 PM3/27/10 12:46 PM