Merging or splitting sheet cells

Within a row or several rows, you can merge adjacent cells into one, or split a merged cell into single cells.

About this task

A merged cell takes its content and styles from the first cell in the original range. In team-based editing, only edits to this first cell are retained if another person simultaneously merges the cells in the range.

Splitting a merged cell restores the content and styles of the original cells.

To merge or split cells, perform the following steps:


  1. Select the cells or cell to be merged or split.
  2. Click the Merge or Split Cells icon Merge/Split Cells icon.
    Then the multiple cells that you select are merged together, or the merged cell that you select is split.