/text/scalc/01/05060000.xhp Sun Microsystems, Inc. UFI: see spec "Merge cells function changed to toggle" dedr: reviewed

Merge and Center Cells Combines the selected cells into a single cell or splits merged cells. Aligns cell content centered.

Choose Format - Merge Cells - Merge and Center Cells

The merged cell receives the name of the first cell of the original cell range. Merged cells cannot be merged a second time with other cells. The range must form a rectangle, multiple selection is not supported. If the cells to be merged have any contents, a security dialog is shown. Merging cells can lead to calculation errors in formulas in the table.