Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
Making Your Worksheet Look Good
Top Align Middle Align Bottom Align
Choose Home>Alignment>Merge & Center. All the
selected cells merge into one larger cell, and the
data is centered horizontally. If you select cells
vertically and choose the Merge and Center
command, Excel merges the cells and vertically
bottomaligns the data. See Figure 10-16, which shows cells
A1 through E1 merged horizontally as well as cells
A2 through E2.
Merge & Center
Vertical cell alignment.
Sometimes the rectangular grid can get in the way
of your design creativity. Perhaps just one cell in
the worksheet is too small, or you want to center
text across a group of columns to create attractive
headings. Fortunately, you can merge multiple
cells. Select the cell containing the data you want
to merge and the cells you want to include in the
merge. The data cell must be in the left cell of the
selection and the other cells cannot contain data,
as shown in Figure 10-15.
Merging cells can create a title for the worksheet.
In this example, it appears that the
heading is located in Columns A through E;
however, the text is still in Column A. If
you need to change the text, be sure to
select Column A, not Column B, C, or D.
After clicking Merge & Center, you can change the
alignment. Click the Merge & Center button again
to unmerge the cells from each other.
Selecting the cells you want to merge.