How to Merge Cells in Apple Numbers (And What to Know Before You Do)

Merging cells is one of those spreadsheet tasks that sounds simple but hides a few surprises. Apple Numbers handles it a little differently than Excel or Google Sheets — and knowing those differences upfront saves you from losing data or formatting headaches later.

What "Merging Cells" Actually Does

When you merge cells, you combine two or more adjacent cells into a single, larger cell. The merged cell spans the space that the individual cells occupied, and it behaves as one unit for formatting, alignment, and data entry purposes.

This is commonly used for:

• Header rows that label a group of columns beneath them
• Title cells that span the full width of a table
• Visual grouping to make a layout cleaner and easier to read

It's a formatting tool, not a calculation tool. Merging doesn't affect formulas in other cells unless those formulas referenced the specific cells you merged.

How to Merge Cells in Numbers on a Mac 🖥️

1. Open your Numbers spreadsheet and click on the first cell you want to include in the merge.
2. Hold Shift and click to select additional adjacent cells. You can select across rows, columns, or both — as long as the selection forms a rectangle.
3. In the top menu bar, go to Format > Table > Merge Cells.
4. The selected cells will combine into one.

Alternatively, right-click your selection and look for Merge Cells in the context menu — this is often faster once you get used to the workflow.

To unmerge, select the merged cell and go back to Format > Table > Unmerge Cells. The same option appears in the right-click menu.

How to Merge Cells in Numbers on iPhone or iPad 📱

The touch-based version follows a slightly different path:

1. Tap a cell to select it, then drag the selection handles to highlight the cells you want to merge.
2. Tap the Format button (the paintbrush icon in the top-right corner).
3. Navigate to the Table tab.
4. Tap Merge Cells.

The option will only appear when a valid, multi-cell rectangle is selected. If you don't see it, double-check that your selection is a proper rectangular block.

The Data Rule You Need to Know

Here's where Numbers differs from what some users expect: if the cells you're merging contain data, Numbers keeps only the content from the upper-leftmost cell and discards the rest.

This means:

• Merging cells with text in multiple cells = you lose everything except the top-left value
• Merging empty cells = no data loss, works cleanly
• Merging cells with numbers you're using in formulas = downstream formula references may break or return unexpected results

Numbers will typically warn you before discarding data, but it's worth double-checking your content before confirming the merge.

When Merging Works Well — and When It Causes Problems

Sorting is the most common friction point. Numbers doesn't allow sorting a table that contains merged cells — you'll need to unmerge first, sort, and then reapply the merge if needed. This is a known limitation of merged cells across most spreadsheet apps, not just Numbers.

Merging vs. Other Visual Formatting Options

Merging cells is sometimes used when a different approach would actually serve better:

• Text alignment across cells: If you just want text to appear centered across multiple columns without merging, adjusting column widths and using center alignment can achieve a similar visual effect without the structural tradeoffs.
• Table headers vs. body cells: Numbers allows you to designate specific rows or columns as header rows/columns with their own formatting — this is often cleaner for structured data than merging body cells.
• Styled text boxes: For titles or labels that sit above a table, a floating text box in Numbers may give you more layout flexibility than merging table cells.

The right approach depends on whether your table is primarily a data table (where sorting, filtering, and formula use matter) or a visual layout (where appearance takes priority over function).

Numbers vs. Excel: Key Difference Worth Noting 🔍

Users switching from Excel sometimes expect "Center Across Selection" — a formatting option that visually centers content across multiple cells without actually merging them. Numbers does not have this feature. Merging is the primary method for spanning content across cells in Numbers.

This distinction matters if you're collaborating on files that move between Numbers and Excel. Merged cells generally translate between formats, but edge cases exist depending on how complex the merge structure is.

What Shapes Your Experience

How straightforward or complicated merging feels in Numbers depends on factors specific to your situation:

• How your table is structured — whether it's a header-only merge or merges scattered throughout the body
• Whether your data uses formulas that reference individual cells you're considering merging
• How you use the file — static reports tolerate merges well; dynamic, sortable datasets generally don't
• Which version of Numbers you're on — the interface for finding merge options has shifted slightly across macOS and iPadOS updates

A table built purely for presentation handles merging differently than one built for data analysis — and what works seamlessly in one context can introduce real friction in the other.