Combining Cells in Excel: A Step-by-Step Guide

Richard Drury via Getty Images

Merging cells in Excel allows for easy formatting of spreadsheets, either vertically or horizontally.

Also: How to enable markdown in Google Docs

For instance, a merged cell at the top of a table can serve as a header or categorize data by groupings.

How to merge cells in Excel

It’s important to note that the data in the first cell selected will be displayed in the merged cell, while content from other cells will be deleted when cells are merged.

The first cell you select should contain the information you want on your merged cell.

Screenshot by Maria Diaz/ZDNET

Clicking Merge & Center will combine the selected cells into one, effectively occupying the space of the other cells and can be repeated for vertical column merging.

Screenshot by Maria Diaz/ZDNET


How do I unmerge cells?

To unmerge cells, simply click on the merged cell, and select the Merge & Center button.

Also: How to use ChatGPT to write Excel formulas

Clicking the button will automatically separate the merged cells, although a dropdown menu to the right will offer the option to unmerge cells.

How can I combine full columns or rows?

To merge columns or rows, select them and then click Merge & Center in the Home tab on Excel.