Microsoft Office Tutorials and References
In Depth Information
Merging or splitting cells or data
Merging or splitting cells or data
You can change a row’s height or a column’s width, but this
might not be the best way to improve your worksheet’s
usability. For example, a label might not fit within a single cell, and
increasing that cell’s width—or every cell’s width—might throw
off the worksheet’s design. One solution to this problem is to
merge two or more cells. Merging cells allows you to treat a
group of cells as a single cell as far as content and formatting
go.
Merge several cells into one
1 Select the cells that you want to merge.
2 Click the Home tab.
3 In the Alignment group, click the Merge & Center button.
2
1
3
CAUTIoN If the cells you select have data in more than one
cell, only the data in the upper-left cell remains after you merge
the cells.
TIP If you do not want the merged data centered, select the
merged cell and click a different alignment in the Alignment
group on the Home tab.
Search JabSto ::




Custom Search