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

Formatting Tables from the Ribbon 141
If Excel does not correctly guess the range of the data table you want to format, drag through the cell range to adjust the marquee and the range address in the Where Is the Data for Your Table? text box. If your data table doesn’t use column headers, click the My Table Has Headers check box to deselect it before you click the OK button — Excel will then add its own column headings (Column1, Column2, Column3, and so forth) as the top row of the new table.
Keep in mind that the table formats in the Table Styles gallery are not avail- able if you select multiple nonadjacent cells before you click the Format as Table command button on the Home tab. You can convert only one range of cell data into a table at a time.
After you click the OK button in the Format As Table dialog box, Excel applies the format of the thumbnail you clicked in the gallery to the data table, and the command buttons on the Design tab of the Table Tools con- textual tab appear on the Ribbon. (See Figure 2-7.)
Figure 2-7:
After you select an initial table format,
the Design tab under Table Tools appears.
As you can see in Figure 2-7, when Excel defines a range as a table, it auto- matically adds AutoFilter drop-down buttons to each of the column headings (the little buttons with triangle pointing downward in the lower-right corner
Book II Chapter 2
Formatting Worksheets