Merge and Unmerge Cells /text/scalc/guide/table_cellmerge.xhp merge/merging cells unmerge/unmerging cells split/splitting cells
Merge and Unmerge Cells You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells.
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. Merge Cells
Click and drag to select the cells to be merged then do one of the following: In the Formatting toolbar click: Or, right click the selection to open the context menu and choose Merge Cells.
If Unmerge Cells is present instead then the cell selection contains merged cells and cannot be merged further.
Or, in the Properties sidebar mark the Merge Cells checkbox. Or, choose Format - Merge and Unmerge Cells - Merge Cells Or, choose Format - Merge and Unmerge Cells - Merge and Center Cells The cells will be merged and the content will be centered in the merged cell.
Unmerge Cells
Select the cell to be unmerged, or a selection that includes the cells to be unmerged then do one of the following: In the Formatting toolbar, click: Or, right click the selection to open the context menu and choose Unmerge Cells.
If Merge Cells is present instead then the selection does not contain any merged cells.
Or, in the Properties sidebar clear the Merge Cells checkbox. Or, choose Format - Merge and Unmerge Cells - Unmerge Cells. Or, toggle Format - Merge and Unmerge Cells - Merge and Center Cells