Microsoft Office Tutorials and References
In Depth Information
To Format the Worksheet Titles
3
Select the range A1:H2 and then
click the Fill Color button arrow on
the Ribbon.
Font Color
button arrow
Click Orange, Accent 1 (column 5,
row 1) on the Fill Color palette.
Click the Font Color button arrow
on the Ribbon and then select
White, Background 1 (column 1,
row 1) on the Font Color palette
(Figure 3–42).
Fill Color
button arrow
fi ll color and font
color of range
A1:H2 changed
Figure 3–42
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click Fill tab to
color background (or
click Font tab to color
font), click OK button
2. Press CTRL +1, click Fill tab
to color background (or
click Font tab to color
font), click OK button
To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell
The next step to improving the appearance of the worksheet is to format the heading
in row 3 and the totals in rows 4, 14, and 16. The following steps format the heading in row 3
with the Heading 3 cell style and the totals in rows 4, 14, and 16 with the Total cell style.
Cell A4 also is formatted.
1 Select the range A3:H3 and apply the Heading 3 cell style.
2 Select the range A6:H6 and while holding down the CTRL key, select the ranges A14:H14
and A16:H16.
3 Apply the Total cell style.
4 Click cell A4, click the Fill Color button arrow on the Ribbon, and then click the Orange,
Accent 1 color (column 5, row 1) on the Fill Color palette.
The Fill and Font Color
Button
You may have noticed
that the color bar at the
bottom of the Fill Color
and Font Color buttons
on the Home tab on the
Ribbon (Figure 3-42)
changes to the most
recently selected color.
To apply this same color
to a cell background or
text, select a cell and
then click the Fill Color
button to use the color as
a background or click the
Font Color button to use
the color as a font color.
5 Click the Font Color button arrow on the Ribbon, and then click the White, Background 1
color (column 1, row 1) on the Font Color palette (Figure 3–43).
Heading 3 cell
style applied
font color and fi ll
color changed
Total cell
style applied
Figure 3–43
 
 
Search JabSto ::




Custom Search