Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To Format the Worksheet Titles
The following steps emphasize the worksheet titles in cells A10 and A11 by changing the font, size, and color.
The steps also format all of the row headers in column A with a bold font style.
1
CTRL + HOME to select cell A1
and then click the column A heading
to select the column.
Press
Bold button
Click the Bold button (Home tab |
Font group) to bold all of the data
in the selected column.
Select cell A10, click the Font Size
Font group
box arrow (Home tab | Font group),
and then click 36 in the Font Size
list to increase the font size of the
selected cell.
Select cell A11, click the Font Size
box arrow, and then click 18 in the
Font Size list to increase the font size
of the selected cell (Figure 3 – 44).
font size of cell A10
changed to 36 and
font size of cell A11
changed to 18
Figure 3 – 44
2
Home tab
Font Color
button arrow
Select the range A10:I11 and then
click the Fill Color button arrow
(Home tab | Font group) to display
the Fill Color gallery.
Click Purple, Accent 2, Darker 25%
(column 6, row 5) in the Fill Color
gallery to add a background color
to the selected range.
Font group
Fill Color
button arrow
Click the Font Color button arrow
(Home tab | Font group) and
then select White, Background 1
(column 1, row 1) in the Font Color
gallery to change the font color of
the selected range (Figure 3 – 45).
i ll color and font
color of range
A10:I11 changed
Figure 3 – 45
Other Ways
1. Right-click range, click
Format Cells on shortcut
menu, click Fill tab
(Format Cells dialog box)
to color background (or
click Font tab to color
font), click OK button
2. Press CTRL + 1, click Fill
tab (Format Cells dialog
box) to color background
(or click Font tab to color
font), click OK button
 
Search JabSto ::




Custom Search