Microsoft Office Tutorials and References
In Depth Information
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle
To Format the Worksheet Titles
The most popular
background color is
blue. Research shows
that the color blue is
used most often because
this color connotes
serenity, reﬂ ection, and
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.
1 Click the Home tab on the Ribbon.
2 Select the range A1:J1 and then click the Merge & Center button on the Ribbon.
3 Select the range A2:J2 and then click the Merge & Center button on the Ribbon.
4 Select the range A1:A2, click the Cell Styles button on the Ribbon, and then click the Title
cell style in the Cell Styles gallery.
5 Select cell A2 and then click the Decrease Font Size button on the Ribbon (Figure 2–33).
What is the effect of clicking the Decrease Font Size button?
When you click the Decrease Font Size button Excel assigns the next lowest font size in the
Font Size gallery to the selected range. The Increase Font Size button works in a similar
manner, but causes Excel to assign the next highest font size in the Font Size gallery to the
Cell Styles button
font size of worksheet
The ﬁ nal formats assigned to the worksheet title and subtitle are the turquoise background color and thick
box border (Figure 2–30b on page EX 107). The following steps complete the formatting of the worksheet titles.
• Select the range A1:A2
and then click the
Fill Color button
arrow on the Ribbon
to display the Fill
Fill Color button arrow
Fill Color palette
range A1:A2 is