Microsoft Office Tutorials and References
In Depth Information
You can apply the Format As Table command to any region of cells (that is, a contiguous
block of cells on a worksheet). You select a cell anywhere within the region, click Format As
Table, and then select one of the sample table formats from the gallery. When you do, Excel
displays the Format As Table dialog box, which lets you adjust the selection, as shown in
Figure 9-5 The Format As Table dialog box appears after you select a format in the Format As
If your table includes headers (as most do), select the My Table Has Headers check box in
the Format As Table dialog box. Excel then selects the entire table automatically and applies
the selected table format to it.
Here are a few tips to keep in mind when using Format As Table:
If you don’t like the way something looks, click the Undo button on the Quick Access
Toolbar (or press Ctrl+Z).
● The boundaries of a table are defined by blank rows and columns or the edges of the
worksheet. Try adding blank columns or rows around your table to effectively fence
off areas you don’t want Format As Table to touch.
Select more than one cell before issuing the command, and Format As Table affects
only the selected cells.