What are contiguous cells

Merge or split cells in Numbers on Mac

When table cells are merged, adjacent cells are merged into a single cell. When dividing cells that were previously merged, all of the data in the new cell in the upper left is retained.

Here are some limitations:

  • It is not possible to merge cells that are not contiguous or from different areas of a table; B. Cells from standard lines and cells from title lines.

  • It is not possible to merge columns or rows.

  • It is not possible to divide a cell. If a cell has never been merged with another cell, it cannot be split.

Note: Forms cannot be used in tables with merged cells. Forms in a spreadsheet created in Numbers for iPad or for iPhone are hidden when you open the spreadsheet in Numbers for Mac. In Numbers for Mac, merging cells in a table that is linked to a form may delete the form.

connecting cells

  1. Select two or more adjacent cells.

  2. Control-click the cells, then choose Merge Cells.

    Note: If the Merge Cells command is grayed out, you may have selected entire columns or rows, or a title cell and a standard cell that cannot be merged even if they are adjacent.

Merging cells has the following results:

  • If only one of the cells contains content before merging, the content and formatting of that cell will be retained in the merged cell.

  • If multiple cells contain content before merging, all of the content is retained. However, cells with a specific data format such as number, currency, or date are converted to text.

  • If a fill color is applied to the top left cell, the fill color for the merged cell is used.

  • If you've used a form to enter data in a table, you won't be able to merge cells in that table.

Divide cells

  • Control-click the cells, then choose Split Cells.

    All the contents of the previously merged cells will be displayed in the first cell after splitting.

Note: When it comes to connected cells in formulas, there are some special features to consider:

  • You can refer to such a cell directly in a formula by entering the address (e.g. C3) in the upper left corner of the connected cell.

  • It is not possible to add only part of the contents of a merged cell to a range of cells used in a formula.

  • If you refer to a cell in a formula and later merge that cell with other cells that are outside the range expected by the formula, an error may occur when the formula is calculated.