Microsoft Office Tutorials and References
In Depth Information
Applying workbook themes and
Enter a name for the new style, select the first table element you want to format, and then
click Format to display the Format Cells dialog box. Define the element’s formatting, and
then click OK. When the New Table Style dialog box reopens, its Preview pane displays
the overall table style and the Element Formatting area describes the selected element’s
appearance. Also, in the Table Element list, Excel displays the element’s name in bold to
indicate it has been changed. To make the new style the default for new Excel tables
created in the current workbook, select the Set As Default Table Style For This Document
check box. When you click OK, Excel saves the new table style.
TIP To remove formatting from a table element, click the name of the table element and
then click the Clear button.
In this exercise, you’ll create a new workbook theme, change a workbook’s theme, create a
new table style, and apply the new style to an Excel table.
SET UP You need the HourlyTracking workbook located in the Chapter04 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
If necessary, click any cell in the Excel table to make the table active.
On the Home tab, in the Styles group, click Format as Table , and then click the style
at the upper-left corner of the Table Styles gallery. Doing so applies the style to the
On the Home tab, in the Styles group, click Format as Table , and then click New
Table Style to open the New Table Style dialog box.
In the Name field, enter Exception Default .
In the Table Element list, click Header Row .
Click Format to open the Format Cells dialog box.
Click the Fill tab to display the Fill page.