Microsoft Office Tutorials and References
In Depth Information
EX 112
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
4
Click the Thick Box Border
command on the Borders
gallery 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 3-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
C6161_EXC_02.4c.indd 112
C6161_EXC_02.4c.indd 112
3/6/07 3:28:53 PM
3/6/07 3:28:53 PM
 
Search JabSto ::




Custom Search