Microsoft Office Tutorials and References
In Depth Information
Controlling the size of cells
Figure 9-62 The Merge & Center button offers a variety of merge commands.
When you merge cells, you end up with a single cell that comprises the original cells. If in
the worksheet shown in Figure 9-63, you select cells A4:B5 and click the Merge Across
command, the result would be two merged cells, A4 and A5, each spanning two columns. Here
are the differences between the Merge & Center commands:
Merge & Center This command consolidates all selected cells—both rows and
columns—into one big cell and centers the contents across the newly merged cell.
This command consolidates each row of selected cells into one wide
cell per row.
Merge Cells This command consolidates all selected cells into one big cell, but it
does not center the contents.
Unmerge Cells This command returns a merged cell to its original component cells
and places its contents in the upper-leftmost cell. Clicking the Merge & Center
button (not the Merge & Center command) when a merged cell is selected has the same
effect, like a toggle “turning off” the merge.
Figure 9-63 shows the same worksheet shown in Figure 9-62 after merging cells A1:B3,
C1:F3, G1:J5, A4:B4, A5:B5, D4:F4, D5:F5, D6:E6, A6:A7, B6:C7, F6:F7, G6:G7, H6:H7, I6:I7, and
J6:J7. We had to shuffle some of the text, before merging so that we wouldn’t lose it to the
merging process. For example, the text in the original range G1:J5 was unevenly spaced
because of the different row heights needed to accommodate the text in cells A1 and C2.
To eliminate this problem, we used the Merge Cells command on the range A1:B3, we used
the Merge & Center command on the ranges C1:F3 and G1:J5, and then we reentered the