Part I: Getting Started with Excel
For a different set of color choices, choose Page Layout ➪ Themes ➪ Themes to select a dif-
ferent document theme.
For more information about themes, see Chapter 5.
You can change some elements of the style by using the check box controls in the Table
Tools Design ➪ Table Style Options group. These controls determine whether various ele-
ments of the table are displayed and whether some formatting options are in effect:
Header Row Toggles the display of the header row.
Total Row Toggles the display of the total row.
First Column Toggles special formatting for the first column. Depending on the table
style used, this command might have no effect.
Last Column Toggles special formatting for the last column. Depending on the table style
used, this command might have no effect.
Banded Rows Toggles the display of banded (alternating color) rows.
Banded Columns Toggles the display of banded columns.
Filter Button Toggles the display of the drop-down buttons in the table’s header row.
If applying table styles isn’t working, it’s probably because the range was already formatted before you converted it
to a table. Table formatting doesn’t override normal formatting. To clear existing background fill colors, select the
entire table and choose Home ➪ Font ➪ Fill Color ➪ No Fill. To clear existing font colors, choose Home ➪ Font
Font Color ➪ Automatic. To clear existing borders, choose Home ➪ Font ➪ Borders ➪ No Border. After you issue
these commands, the table styles should work as expected.
If you’d like to create a custom table style, choose Table Tools Design ➪ Table Styles ➪ New
Table Style to display the New Table Style dialog box shown in Figure 4.29. You can custom-
ize any or all of the 12 table elements. Select an element from the list, click Format, and
specify the formatting for that element. When you’re finished, give the new style a name
and click OK. Your custom table style will appear in the Table Styles gallery in the Custom
categor y.
Custom table styles are available only in the workbook in which they were created.
However, if you copy a table that uses a custom style to a different workbook, the custom
style will be available in the other workbook.
