Merge or unmerge cells in Numbers on iPhone
Merging table cells combines adjacent cells into a single cell. Unmerging cells that were previously merged retains all the data in the new top-left cell.
Here are some restrictions:
You canβt merge nonadjacent cells or cells from different areas of the tableβfor example, cells from the body and the header.
You canβt merge columns or rows.
You canβt split a cell. If a cell has never been merged with another cell, it canβt be unmerged.
Note: You canβt use forms for tables with merged cells. Forms in a Numbers for iPhone or iPad spreadsheet are hidden when you open the spreadsheet in Numbers for Mac. In Numbers for Mac, merging cells in a table linked to a form may clear the form.
Merge cells
Go to the Numbers app
on your iPhone.Open a spreadsheet, then select two or more adjacent cells.
Tap
in the bottom-right corner of the screen, then tap Merge Cells.Note: If you donβt see Merge Cells, you might have selected entire columns or rows, or a header cell and a body cell, which canβt be merged, even if theyβre adjacent.
These are the results of merging cells:
If only one of the cells contains content prior to merging, the merged cell retains the content and formatting of that cell.
If multiple cells contain content before merging, all the content is retained, but cells with a specific data format, such as numbers, currency, or dates, are converted to text.
If a fill color is applied to the top-left cell, the merged cell takes on the fill color.
If you used a form to enter data into a table, you canβt merge any of the cells in the table.
Unmerge cells
Go to the Numbers app
on your iPhone.Open a spreadsheet, then tap the cell.
Tap
in the bottom-right corner of the screen, then tap Unmerge Cells.All of the content and formatting from the previously merged cell appears in the first unmerged cell.
Note: Merged cells are treated specially in formulas:
To refer to the cell directly in a formula, use the address of the merged cellβs top-left corner (for example, C3).
You canβt include only part of a merged cell in a cell range thatβs used in a formula.
If you refer to a cell in a formula and then merge the cell with cells outside the formulaβs intended range, the formula may result in an error.