Numbers - Merging Table Cells

background image

Merging Table Cells

Merging table cells combines adjacent cells into one, eliminating the borders so that
they behave as a single cell.

To merge table cells:

1

Select a group of two or more adjacent table cells. The group of cells you choose must

form a rectangle, and they must be all body cells, all header cells, or all footer cells.

2

Choose Table > Merge Cells.

You can also click the Merge button in the Table inspector.

To unmerge cells, select a cell created by merging, and then deselect Merge Cells in
the Table menu or click the Unmerge button in the Table inspector.

Here is what happens to cell content during a merger:

Merging horizontally contiguous cells containing only text or a mixture of text,

Â

numbers, formatted values, and formulas joins the content from all the original cells
as text separated by tabs.
Merging vertically contiguous cells containing only text or a mixture of text,
numbers, formatted values, and formulas joins the content from all the cells as text
separated by carriage returns.

86

Chapter 4

Working with Table Cells

background image

Chapter 4

Working with Table Cells

87

When you merge column cells, the cell background takes on the image or color that

Â

was in the topmost cell.
When you merge row cells, the cell background takes on the image or color that
was in the leftmost cell.
When a cell containing text, a number, a formula, or a cell format is merged with an

Â

empty cell, the new cell retains the content of the non-empty cell.
When a cell containing a number format is merged with an empty cell, the new cell

Â

retains the number format.

Rows and columns that contain merged cells can’t be hidden.