Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
3
A2 is active cell
Repeat Steps 1 and 2
to merge and center
the worksheet
subtitle across cells
A2 through H2
(Figure 1– 40).
Are cells B1 through
H1 and B2 through H2
lost forever?
No. The opposite
of merging cells is
splitting a merged
cell . After you have
merged multiple cells
to create one merged
cell, you can unmerge,
or split, the merged
cell to display the
original cells on the
worksheet. You split a merged cell by selecting it and clicking the Merge & Center button.
For example, if you click the Merge & Center button a second time in Step 2, it will split the
merged cell A1 into cells A1, B1, C1, D1, E1, F1, G1, and H1.
cells A2 through H2
merged to create
new cell A2
entry in cell A2
centered across
columns A through H
Figure 1– 40
Other Ways
1. Right-click selection, click
Merge & Center button
on Mini toolbar
2. Right-click selection, click
Format Cells on shortcut
menu, click Alignment
tab (Format Cells dialog
box), select Center Across
Selection in Horizontal
list, click OK button
To Format Column Titles and the Total Row
The next step to format the worksheet is to format the column titles in row 3 and the total values in row 9.
Column titles and the total row should be formatted so anyone who views the worksheet quickly can distinguish the
column titles and total row from the data in the body of the worksheet. The following steps format the column titles
and total row using cell styles in the default worksheet theme.
1
Click cell A3 and
then drag the mouse
pointer to cell H3
to select a range
(Figure 1– 41).
Why is cell A3 selected
in the range for the
column headings?
The style to be
applied to the column
headings includes an
underline that will
help to distinguish
the column headings
from the rest of the
worksheet. Including
cell A3 in the range ensures that the cell will include the underline, which is visually
appealing and further helps to separate the data in the worksheet.
range A3:H3 selected
Figure 1– 41
 
Search JabSto ::




Custom Search