Microsoft Office Tutorials and References
In Depth Information
Using the Format as Table Gallery
As soon as you click one of the table formatting thumbnails in this Table
Styles gallery, Excel makes its best guess as to the cell range of the data
table to apply it to (indicated by the marquee around its perimeter) and the
Format As Table dialog box, similar to the one shown in Figure 3-5, appears.
its range in
This dialog box contains a Where Is the Data for Your Table text box that
shows the address of the cell range currently selected by the marquee and a
My Table Has Headers check box.
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 or, if the table has them, but you still don’t want
Excel to add Filter drop-down buttons to each column heading, deselect the
My Table Has Headers check box before you click the OK button.
The table formats in the Table Styles gallery are not available if you select
multiple nonadjacent cells before you click the Format as Table command button
on the Home tab.
After you click the OK button in the Format As Table dialog box, Excel applies
the formatting of the thumbnail you clicked in the gallery to the data table.
Additionally, the Design tab appears under the Table Tools contextual tab at
the end of the Ribbon, and the table is selected with the Quick Analysis tool
appearing in the lower-right corner, as shown in Figure 3-6.