Merging and splitting cells

You can use the Format > Merge Cells... command to "merge" adjoining cells. When a group of cells is merged, the contents of the top-left cell of that group is displayed within the entire merged area. The remaining merged cells are treated as covered and they are not displayed.

Merging doesn't change how the merged cells are referenced in formulas, how they are copied, edited or formatted. For example, to edit the contents displayed within the merged group or format it, you must apply that action the top-left left cell of that group.

The Merge Cells dialog box enables you to specify the following additional options:

Merge selected cell contents and place it the top-left cell

The contents of all cells within the merged group will be concatenated and copied to the top-left cell. Merged cells are separated by a single space and lines of cells are separated by new-line characters. Merged and copied cells are deleted.

Alignment options

You can adjust any of the current alignment options for the top-left cell. To modify them later, select the top-left merged cell and use any of the style editing command.

Save As Defaults / Reset Defaults

Click the "Save As Defaults" button to save the specified alignment options for subsequent cell merging operations. If there are already some saved/predefined alignment settings, the title of this button changes to "Reset Defaults", which causes this dialog box to use the current format of the top-left cell of the merged selection.

To split (merged) cells, select a given group of merged cells (or at least the top-left cell) and use the Format > Split command.

To find all merged cell groups, use View > Inspect Cells command to open the Inspect Cells pane, click the Find & Add button and choose the Merged Cells command.