Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet EX 41
2
Click the Merge and Center button
on the Ribbon to merge cells A1
through G1 and center the contents of
cell A1 across columns A through G
(Figure 1–59).
formats assigned
to active cell A1
A1 is
active cell
Merge and
Center button
What happened to cells B1
through G1?
After the merge, cells B1 through G1
no longer exist. Cell A1 now extends
across columns A through G.
cells A1 through
G1 merged to
create new cell A1
heavy border
indicates new
dimensions
of cell A1
entry in cell
A1 centered
across columns
A through G
Figure 1–59
3
Repeat Steps 1 and 2
to merge and center
the worksheet subtitle
across cells A2 through
G2 (Figure 1–60).
A2 is
active cell
Are cells B1 through
G1 and B2 through G2
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 and Center button. For example, if you click the Merge and
Center button a second time in Step 2, it will split the merged cell A1 to cells A1, B1, C1, D1, E1,
F1, and G1.
cells A2 through
G2 merged to
create new cell A2
entry in cell
A2 centered
across columns
A through G
Figure 1–60
Other Ways
1. Right-click selection, click
Merge and Center button
on Mini toolbar
2. Right-click selection, click
Format Cells on shortcut
menu, click Alignment
tab, select Center Across
Selection in Horizontal list,
click OK button
Search JabSto ::




Custom Search