Microsoft Office Tutorials and References
In Depth Information
Build a Custom Table Style
Chapter 3: Customizing Worksheet Presentation
The Format Cells dialog
7 Use the tabs to select the
formatting options you
want in your cell style.
Note: Depending on the table
element you are working with, some
of the formatting options may be
8 Click OK.
9 Repeat steps 5 to 8 to set
the formatting for the
other table elements, as
0 Click OK in the New
Table Quick Style dialog
box (not shown).
! Click Format as Table.
Your table styles appear
in the Custom section of
the Table Styles gallery.
If you want to use your custom table style
for all or most of the tables you create,
you should set the custom style as the
default. When you are creating a new
custom table style, follow steps 1 to 9 and
then click to select the Set as Default
Table Quick Style for This Document
option. For an existing custom table style,
click the Home tab, click Format as Table,
right-click the custom style, and then click
Set As Default.
If you no longer need a custom table
style, you should delete it to reduce
clutter in the Table Styles gallery. Click
the Home tab and then click Format as
Table to open the Table Styles gallery.
Right-click the custom table style, click
Delete, and then click OK. Excel deletes
the custom table style. Tables formatted
with the style revert to the default table