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.


Kunfandi ĉelojn

  1. Elektu la apudajn ĉelojn.

  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. Metu la kursoron en la dividotan ĉelon.

  2. Choose Format - Merge Cells - Split Cells.

Referencing Other Sheets