1. Merging Cells
You can merge adjoining cells using the Format > Merge Cells... command. When cells are merged, the contents of the top‑left cell are displayed across the entire merged area. All other cells in the merged group are treated as covered and are not displayed.
Merging does not change how formulas reference the merged cells, nor how they are copied, edited, or formatted. To edit or format the displayed content, you must select the top‑left cell of the merged group.
Merged ranges may be of any size, but they cannot overlap.
2. Merge Cells Dialog Options
Merge selected cell contents and place them in the top‑left cell
The contents of all cells in the merged group are concatenated and copied into the top‑left cell. Cells are separated by a single space, and rows are separated by newline characters. All merged cells are then cleared.
Alignment options
You can adjust alignment settings for the top‑left cell. To modify alignment later, select the top‑left merged cell and use any formatting command.
Save As Defaults / Reset Defaults
Click Save As Defaults to store the current alignment settings for future merge operations. If defaults already exist, the button changes to Reset Defaults, which restores the dialog’s settings to match the current format of the top‑left cell.
3. Splitting Cells
To split merged cells, select the merged group (or at least the top‑left cell) and use Format > Split.
4. Finding Merged Cells
To locate all merged cell groups, open the Inspect Cells pane using View > Inspect Cells, click Find & Add, and choose Merged Cells.