Video: Merge cells or split merged data

When you merge two or more adjacent cells, the cells become one larger cell that is displayed across multiple columns or rows. Make sure that the data that you want to display in the merged cell is contained in the upper-left cell of the selected range. Only the data in the upper-left cell will remain in the merged cell. Data in all the other cells of the selected range will be deleted.

You can split a merged cell into separate cells again by undoing its merge.

If you don't remember where you have merged cells, you can use the Find command to quickly locate merged cells.