How to Merge Cells in Excel

Cell merging is one of the basic features of Excel in formatting worksheets, available in vertical and horizontal patterns. A merged cell at the top of a table can serve as a header or delimit a category.

If you’ve ever wondered how to merge cells, we’ll walk you through the process:

How to Merge Cells in Excel

How to Merge Cells in Excel

Image: Maria Diaz/ZDNet

Step 1: Select cells to merge into one

Select cells to merge

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

Image: Maria Diaz/ZDNet

Keep in mind that the information on the first cell to be selected is what will go on the combined cell, so the contents of any other selected cells will be deleted once you merge the cells.

Step 2: On the Home tab, click Merge and Center

Click Merge and Center and the cells will be merged

Image: Maria Diaz/ZDNet

The cells will be merged into one, occupying the real estate of the other cells you selected. This can be done in columns vertically by repeating the same process.


How to dissociate cells?

Click on the merged cell to select it and access the same Merge and Center button. Clicking this button will automatically split the merged cells together, although there is a drop-down menu to the right of it that will give you the option to unsplit the cells.

How can I combine complete columns or rows?

You can merge columns or rows by selecting them and clicking Merge and Center on Excel’s Home tab.

Comments are closed.