Microsoft Office Tutorials and References
In Depth Information
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle
4
Click the Thick Box Border
command on the Borders gal-
lery to display a thick box border
around the range A1:A2.
Click cell A18 to deselect the
range A1:A2 (Figure 2–37).
Format Cells: Number
Dialog Box Launcher
button
Other Ways
1. On Ribbon click Format
Cells Dialog Box Launcher,
click appropriate tab, click
desired format, click OK
button
2. Right-click range, click
Format Cells on shortcut
menu, click appropriate
tab, click desired
format, click OK button
3. Press CTRL+1, click
appropriate tab, click
desired format, click OK
button
thick box border
surrounds worksheet
title and subtitle in
cells A1:A2
Figure 2–37
To Apply a Cell Style to the Column Headings and Format the
Total Rows
As shown in Figure 2–30b on page EX 107, the column titles (row 3) have the
Heading 3 cell style and the total row (row 13) has the Total cell style. The summary
information headings in the range A14:A16 should be bold. The following steps assign
these styles to row 3 and row 13 and the range A14:A16.
1 Select the range A3:J3.
2 Apply the Heading 3 cell style to the range A3:J3.
3 Apply the Total cell style to the range A13:J13.
4 Select the range A14:A16 and then click the Bold button on the Ribbon (Figure 2–38).
Bold button
Center button
Format Cells Dialog
Box Launcher
column headings
formatted with
Heading 3 cell style
total row formatted
with Total cell style
range A14:A16
formatted bold
Figure 2–38
 
 
Search JabSto ::




Custom Search