Page 613 - Excel 2013 All-in-One For Dummies

Sorting Data 595
Figure 1-9:
Personnel data list after sorting the columns using the values entered in the first row.
Excel deletes the row of numbers and pulls up the Personnel data list so that its row of field names is now in row 1 of the worksheet. Now, all that’s left to do is to reformat the Personnel data list as a table again so that Excel adds AutoFilter buttons to its field names and the program dynamically keeps track of the data list’s cell range as it expands and contracts.
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.
Book VI Chapter 1
Building and Maintaining Data Lists