Microsoft Office Tutorials and References
In Depth Information
Type 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 Quick 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 Quick 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_start workbook located in your Chapter04
practice file folder to complete this exercise. Open the HourlyTracking_start
workbook, and save it as HourlyTracking . Then follow the steps.
1. If necessary, click any cell in the Excel table.
2. 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.
Excel applies the style to the table.
3. On the Home tab, in the Styles group, click Format as Table , and then click New
Table Style .
The New Table Quick Style dialog box opens.
4. In the Name field, type Exception Default .
5. In the Table Element list, click Header Row .
6. Click Format .
The Format Cells dialog box opens.