Merge or unmerge cells

Merge cells

You can merge any number of cells on the current sheet.

When merging cells:

–The selected range becomes a single cell.

–Only the data from the upper-left cell of the range is saved.

–The formatting of the upper-left cell of the range is applied to the merged cell.

To merge cells, select them and do one of the following:

–On the Home tab, in the Cells group, click  Merge cells.

–When working in macOS, select Table > Merge cells command from the command menu.

–Right-click the selected cell range and run the Merge cells command from the context menu.

–Press Ctrl+Alt+M (Windows, Linux) or ⌥Option+⌘Cmd+M (macOS).

Unmerge cells

You can only split those cells that have previously been merged.

To unmerge cells, select the cell created by merging and do one of the following:

–On the Home tab, in the Cells group, click  Unmerge cells..

–When working in macOS, select Table > Unmerge cells command from the command menu.

–Right-click the selected cell and choose Unmerge cells command from the context menu.

–Press Alt+Shift+M (Windows, Linux) or ⌥Option+⇧Shift+M (macOS).

The data that is contained in the merged cell is placed in the upper-left cell of the resulting range. Cells in the range will retain the formatting of the merged cell.