Merging and Unmerging Cells

You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells.

Note Icon

When you copy cells into a target range containing merged cells, the target range gets unmerged first, then the copied cells are pasted in. If the copied cells are merged cells, they retain their merge state.

Merging Cells

  1. Select the adjacent cells.

  2. Choose Format - Merge Cells - Merge Cells. If you choose Format - Merge Cells - Merge and Center Cells, the cell content will be centered in the merged cell.

Splitting Cells

  1. Place the cursor in the cell to be split.

  2. Choose Format - Merge Cells - Split Cells.

Referencing Other Sheets

Please support us!