Microsoft Office Tutorials and References
In Depth Information
The following are the options:
Apply And Clear Formatting sounds backward, because what really happens is that
Excel removes the existing formatting first before applying the selected table format.
Apply (And Maintain Formatting) gives you the option of using the selected table
format without disturbing any format attributes previously applied to the selected
cells. This is handy if you have special number formats or conditional formats you
want to preserve.
Duplicate copies the selected table format; opens the Modify Table Quick Style
dialog box (which is identical to the New Table Style dialog box shown in Figure 9-11),
letting you make modifications; and places the resulting format in the Custom
category at the top of the Format As Table gallery.
Creating custom table formats
If the built-in gallery of table styles doesn’t do it for you, you can create your own. To do so,
click the Format As Table button on the Home tab, scroll to the bottom of the gallery, and
click New Table Style to display the New Table Style dialog box shown in Figure 9-11.
Figure 9-11 Click the New Table Style command in the Format As Table gallery to create your
own table styles.
In the New Table Style dialog box, you can assign font, border, and ill formats to each item
included in the Table Element list. Select the element you want to format, and click the
Format button to display the Format Cells dialog box shown on the right in Figure 9-11. You
can click the Clear button to remove the formatting from a selected element; select the Set
As Default Table Style For This Document check box to make yours the go-to style
whenever you create tables in the current workbook. After you finish specifying formats and