Microsoft Office Tutorials and References
In Depth Information
Merging and unmerging cells
IMPORTANT When you select the header cells, click the Home tab, click Merge & Center, and
then click either Merge & Center or Merge Cells, Excel deletes any text that’s not in the top-left
cell of the selected range.
If you want to split merged cells into their individual cells, click the Home tab, click Merge &
Center, and then click Unmerge Cells.
In this exercise, you will merge cells, unmerge cells, merge and center cells, and use Merge
Across to combine cells in several rows into one merged cell per row.