Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
• Themes gallery to
change the workbook
theme (Figure 2 – 32).
Click Trek in the
font of worksheet cells
rel ects theme’s default font
Figure 2 – 32
Why did the cells in the worksheet change?
The cells in the worksheet originally were formatted with the default font for the default
Ofi ce theme. The default font for the Trek theme is different from that of the default font
for the Ofi ce theme and, therefore, changed on the worksheet when you changed the
theme. If you had modii ed the font for any of the cells, those cells would not receive the
default font for the Trek theme.
To Format the Worksheet Titles
The following steps merge and center the worksheet titles, apply the Title cells style
to the worksheet titles, and decrease the font of the worksheet subtitle.
Display the Home tab.
Select the range to be merged, A1:J1 in this case, and then click the Merge & Center
button (Home tab | Alignment group) to merge and center the text in the selected range.
Select the range A2:J2 and then click the Merge & Center button (Home tab | Alignment
group) to merge and center the text in the selected range.
Select the range to contain the Title cell style, in this case A1:A2, click the Cell Styles
button (Home tab | Styles group) to display the cell styles gallery, and then click the Title
cell style in the Cell Styles gallery to apply the Title cell style to the selected range.
Select cell A2 and then click the Decrease Font Size button (Home tab | Font group) to
decrease the font size of the selected cell to the next lowest font size (Figure 2 – 33 on the