Merge cells

Merge one or more columns (cells) within a row into a single cell. You can also revert the merge and convert the merged cell back to its original number of cells.

About this task

You can only merge the cells within a row. You cannot merge cells across rows.

  1. Select multiple cells.
    Hold down the Ctrl key and click on each cell you wish to merge. As each cell is selected, it turns blue in color.
  2. Right-click and select Merge Cells from the context menu.
  3. To reverse the merge, right-click on the merged cell and select Split Cells from the context menu.
    The merged cell is split back into its original columns. Any content of the merged cell is put into the first column.