Merging cells
Merge cells
To merge cells, take the steps below:
1. Select a range of cells that you want to merge
2. Click the Merge button in the toolbar
or
1. Select a range of cells that you want to merge
2. Go to: Format -> Merge in the menu
The merged cell displays the content of the upper-left cell of the selected range.
Split cells
To split a merged cell, take the steps below:
1. Select the merged cell
2. Click the Unmerge button in the toolbar
or
1. Select the merged cell
2. Go to: Format -> Unmerge in the menu
Removing rows and columns of merged cells
When you remove a row or a column through a merged cell, every row or column that the merged cell spans is removed. It works this way when a cell or a range of cells is selected and the row or column is removed via the toolbar, the menu, the context menu or the deleteRow() / deleteColumn() methods. The context menu shows the full range in the command name, for example, Remove rows 2-4.
When whole rows or columns are selected, for example, by clicking their headers or with Shift + Space or Ctrl (Cmd) + Space, only the selected rows or columns are removed. A merged cell that spans them becomes smaller, and a merged cell left with a single cell becomes an ordinary cell.
Merged cells located below or on the right of the removed rows or columns move together with them.