# How to merge cells in Numbers on Mac: table cells, Control-click steps and fixes

> How to merge cells in Numbers on Mac: select adjacent cells, Control-click them, choose Merge Cells. Covers unmerging, data loss and dimmed menus.

URL: https://www.lazur.app/how-to/merge-table-cells-in-numbers
Updated: 2026-11-06

To merge cells in Numbers on Mac, select two or more adjacent cells, Control-click the selection, and choose Merge Cells. To split a merged cell again, Control-click it and choose Unmerge Cells.

## Quick answer

- Select two or more adjacent cells. Don't select whole rows or columns.
- Control-click the selection and choose Merge Cells. Apple's Mac guide lists no keyboard shortcut for it.
- If several cells hold content, all of it stays, but number, currency and date cells become text.
- To split a merged cell, Control-click it and choose Unmerge Cells. Unmerge moves all content into the first new cell.

Applies to: Numbers for Mac, the desktop app. Not Numbers for iCloud.. Time: 3 min. Difficulty: Easy.

## What you need

- Numbers for Mac open, with a table in the sheet
- Two or more adjacent cells to merge
- A trackpad or mouse that can Control-click

## How to Merge table cells in Numbers on Mac in Numbers on a Mac

1. **Open the table in Numbers for Mac.** Open the spreadsheet in Numbers for Mac and click the table you want to change. Scroll until the cells you need are on screen. Work in the table itself, not in a text box or a chart, because merging applies only to table cells.
2. **Select the cells to merge.** Click the first cell in the block, then drag across the adjacent cells you want to join. The selection must form one connected rectangle, such as B2 through C4. Don't select a whole row or column, because Merge Cells won't be available. Tip: If the selection spans a header and a body, split it into two separate merges.
3. **Control-click the selection.** Control-click inside the selected cells. On a trackpad, a two-finger click works too. The contextual menu opens over the table. Keep the selection highlighted while the menu is open.
4. **Choose Merge Cells.** (Control-click menu > Merge Cells) In the contextual menu, choose Merge Cells. The selected cells join into one cell. The merged cell takes the address of its top-left cell, so formulas should point there. Tip: If Merge Cells is dimmed, the selection broke a rule. The troubleshooting section lists the common causes.
5. **Check the content and formatting.** Click the merged cell and read what's inside. If several cells held values, look for number, currency or date cells that now show as text. Fix those values before you rely on the table. Tip: Apple's guide lists no keyboard shortcut for merging, so use the menu each time.

Merged cells are the quickest way to let one label span several columns. A report title across the top of a table is the usual case. Numbers on Mac handles the job from one menu, but the menu only works when your selection follows a few rules. This guide covers the steps, what happens to your data, and the errors that stop the command from working.

![Person at a laptop working on a spreadsheet table, the kind where you merge cells in Numbers on Mac](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/merge-table-cells-in-numbers/how-to-merge-cells-in-numbers-on-1-5cafdc.jpg)

## How to merge cells in Numbers on Mac, step by step

The merge command lives in the contextual menu, not the menu bar. Apple's Mac guide doesn't list a menu-bar path or a keyboard shortcut for merging. So you start from the selection and work from the Control-click menu. The numbered steps on this page follow that route. Check the labels in your copy, because Apple's page doesn't name the Numbers version it describes.

## Which cells Numbers will merge

Numbers merges one rectangle of adjacent cells. It refuses cells that sit apart, cells that cross from a header into the body, and entire rows or columns. Most failed merges come from one of those three cases. Check the selection first, then right-click.

- Adjacent cells that form one block, such as B2 through C4.
- Cells from the same area. Keep header cells and body cells apart.
- Individual cells. Selecting a whole row or column disables Merge Cells.
- A table that doesn't depend on a form. Tables with merged cells can't use forms, as covered below.

## What happens to your data when you merge

Merging doesn't simply stack everything into one cell. What survives depends on how many cells hold content. Read the table below before you merge a column of prices, dates or totals.

| Situation | What Numbers does |
| --- | --- |
| Only one cell has content | The merged cell keeps that content and its formatting. |
| Several cells have content | All of the content is kept, but number, currency and date cells become text. |
| The top-left cell has a fill color | The fill color carries over to the merged cell. |

_Merge results in Numbers for Mac, per Apple's Mac guide_

Here is a worked example. Say B2 holds a product name, and C2 holds a price formatted as currency. Merge B2 and C2 and both values stay. C2 now shows as text, though, so it no longer behaves like a price. Retype it in a currency cell before you add it to anything.

The safest habit is simple. Merge label cells, and keep numbers, currency and dates in their own cells. If you must merge a value cell, check it straight after the merge.

## How to unmerge cells in Numbers on Mac

Unmerging reverses the layout, but it doesn't bring back lost data. Numbers moves all content from the merged cell into the first new cell. The new cells take the formatting and fill color of the former merged cell, so the block looks the same. Only the first cell holds content.

1. Click the merged cell to select it.
2. Control-click the merged cell.
3. Choose Unmerge Cells from the menu.
4. Read the first cell, then type or paste content back into the other cells.

A cell that was never merged can't be unmerged. The menu item only works on cells you merged earlier. A single cell can't be split either.

## Formulas and merged cells

A merged cell has one address, its top-left cell. Apple's example uses C3. If you merge C3 with D3, every formula refers to C3, and no formula can use part of the merged block inside a cell range. Build formulas after the layout is final, or update them when the layout changes.

Here is a worked example. Say you merge B1 and C1 into a title, and a total sits lower in the sheet. Point any formula that needs the title at B1, not C1. C1 isn't the address to use once the cells are merged.

## Forms and merged cells

Tables with merged cells can't use forms. If a table is linked to a form, merging cells may clear the form. If data already came in through a form, you can't merge any cells in that table. Decide on forms first, then merge.

## Numbers for iCloud works differently

The web app takes a different route. Select the cells, click the Cell tab in the Format sidebar on the right, then click Merge under Merge Cells. To unmerge, select the merged cell and click Unmerge.

The web app has one big difference. Unmerging keeps data only in the top-left cell, so you copy and paste anything else back by hand. Forms from iOS spreadsheets are hidden in Numbers for iCloud, too.

![Person using a MacBook at a desk, reviewing table data before they merge cells in Numbers](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/merge-table-cells-in-numbers/how-to-merge-cells-in-numbers-on-2-9453fc.jpg)

## Why Merge Cells is greyed out

A dimmed command almost always means your selection broke one of the rules above. Work through these checks in order, starting with the selection.

- Click one cell, then drag across the adjacent cells. Avoid selecting a whole row or column.
- Check the header and body split. Don't merge a header cell with a body cell.
- Look for a form link. A table linked to a form can't merge.
- Confirm the cells are touching. Nonadjacent cells are refused.

If none of that fits, you may be on an older setup. An Apple Community thread about Numbers 3.1 on OS X Mavericks describes the same greyed out command. Its fixes included typing a centered title in the middle cell with Wrap Text off. That thread is old, so treat it as a workaround, not a rule.

## Which Numbers version you have

Numbers now ships in two lines. Numbers 15.1 is a separate app that can sit beside 14.5, according to TidBITS. Version 15.1 requires macOS 15.6 Sequoia or later. Version 14.5 supports macOS 14.0 Sonoma and later, and it shows a launch dialog saying it won't receive updates.

Apple's What's new page lists Numbers 15.4 as the newest version. It says Numbers 15.4 for Mac requires macOS 26 or later. The page lists no merge, cell or menu change. The Mac merge guide doesn't name a version, so check the steps in your copy before you rely on them.

## Merged cells and spreadsheet habits

Merged cells look tidy, but they add rules. Formulas, forms and the merge itself all have limits, as covered above. Ask first whether a centered title in one cell would do the same job.

For context, a 2022 survey for ThoughtSpot found that on average 40% of office workers struggle to make sense of their data in spreadsheets. It covered spreadsheets in general, not Numbers on Mac. Treat the figure as background, not a Numbers benchmark.

- **macOS 26** Numbers 15.4 for Mac requires macOS 26 or later, according to Apple's What's new page. ([source](https://support.apple.com/guide/numbers/whats-new-tan700f60676/mac))
- **40%** of office workers struggle to make sense of spreadsheet data, on average. Sapio Research survey, October 2022. ([source](https://www.thoughtspot.com/press-releases/new-research-shows-almost-half-of-users-struggle-to-make-sense-of-data-in-spreadsheets))
- **20+ hours** a month that knowledge workers spend in spreadsheets, per the same ThoughtSpot press release. ([source](https://www.thoughtspot.com/press-releases/new-research-shows-almost-half-of-users-struggle-to-make-sense-of-data-in-spreadsheets))

![Office desk with printed spreadsheet data and a laptop, the setting for checking merged cells in Numbers](https://lfobmih1tpj3sgpo.public.blob.vercel-storage.com/content-images/howto/merge-table-cells-in-numbers/how-to-merge-cells-in-numbers-on-3-ff5bad.jpg)

## Next steps after you merge the cells

Once the layout is set, the usual next jobs are sorting, filtering and formulas. Read [how to sort a table in Numbers on Mac](https://www.lazur.app/how-to/sort-a-table-by-column-in-numbers) next, then [how to add a formula in Numbers on Mac](https://www.lazur.app/how-to/add-a-formula-to-a-cell-in-numbers).

If the file needs to go to someone who doesn't have Numbers, [how to export numbers to pdf on mac](https://www.lazur.app/how-to/export-a-spreadsheet-to-pdf-in-numbers) covers that step.

## Common mistakes with merged cells

- Merging a column of prices. Currency cells turn into text.
- Selecting a header row and a data row together, then wondering why the command is dimmed.
- Trying to unmerge a cell you never merged. Numbers can't split a cell that was never merged.
- Expecting content from other cells to come back after an unmerge. It moves to the first cell.
- Writing a formula that points at a cell inside the merged area.

Before you save, click the merged cell and read it. Check any formula that uses it. If a value now shows as text, retype it in a cell with the right format.

## Shortcuts

- Open the context menu on selected cells: Control-click

## If it does not work

- **Merge Cells is dimmed** Select individual adjacent cells, not whole rows or columns. Keep header cells and body cells in separate merges.
- **Merge Cells won't work on this table** Check for a form link. Tables with merged cells can't use forms, and if data came in through a form, you can't merge any cells in that table.
- **A number, currency or date now shows as text** Merged cells turn those cells into text. Retype the value in a cell with the number, currency or date format you need, then check any formula that uses it.
- **A formula returns an unexpected result after a merge** Point the formula at the merged cell's top-left address. Don't reference a cell inside the merged area, and don't use part of a merged cell inside a range.
- **Unmerge Cells doesn't appear for a cell** Only merged cells can be unmerged. A single cell can't be split, and a cell you never merged has nothing to undo.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is the Merge Cells command?”: Lazur circles Merge Cells in the Control-click menu and labels it. You click the command yourself, because Lazur doesn't click for you. (Points at it)

## FAQ

### Is there a keyboard shortcut to merge cells in Numbers on Mac?

Apple's Mac guide doesn't list one for merging or unmerging. The documented route is the Control-click menu on the selected cells. Use that menu each time, and check the result after you choose Merge Cells.

### Why is Merge Cells greyed out in Numbers on Mac?

The usual causes are an entire row or column selected, or a header cell and a body cell selected together. Select a block of individual, adjacent cells and try again. If the table is linked to a form, merging isn't allowed.

### Does merging cells delete my data in Numbers?

Not always. If only one cell has content, the merged cell keeps it. If several cells have content, Numbers keeps all of it, but cells with number, currency or date formats become text. Check those values after you merge.

### Can I split a cell that was never merged?

No. A cell that was never merged can't be unmerged, and a single cell can't be split. Unmerge works only on cells you merged earlier.

### Where does the content go after I unmerge cells?

Numbers moves all the content from the merged cell into the first new cell. The other new cells take the formatting and fill color of the former merged cell, but they start with no content. Retype or paste what you need.

### Does Numbers for iCloud merge cells the same way?

Not quite. In the web app, select the cells, open the Cell tab in the Format sidebar, and click Merge under Merge Cells. Unmerging keeps data only in the top-left cell, so copy the rest back by hand.

### Which version of Numbers do I need to merge cells?

Apple's Mac merge guide doesn't name a version, and Apple's What's new page lists no merge change for Numbers 15.4. Numbers 15.4 requires macOS 26 or later. Numbers 15.1 requires macOS 15.6 Sequoia or later.

### Can I merge cells in a table that is linked to a form?

Usually not. Tables with merged cells can't use forms. Merging a table linked to a form may clear the form. If data was entered through a form, you can't merge any cells in that table.

### Can I merge an entire column in Numbers?

No. Numbers won't merge entire columns or rows. Select a block of cells inside the column instead, such as the top cells of a title area.

## Sources

1. [Merge or unmerge cells in Numbers on Mac (Apple Support)](https://support.apple.com/guide/numbers/merge-or-unmerge-cells-tan834b645e7/mac), Apple, checked 2026-11-07
2. [Merge and unmerge cells in Numbers for iCloud (Apple Support)](https://support.apple.com/guide/numbers-icloud/merge-and-unmerge-cells-gil77f80713e/icloud), Apple, checked 2026-11-07
3. [What's new in Numbers on Mac (Apple Support)](https://support.apple.com/guide/numbers/whats-new-tan700f60676/mac), Apple, checked 2026-11-07
4. [Pages, Keynote, and Numbers 15 Go Freemium](https://tidbits.com/2026/02/06/pages-keynote-and-numbers-15-go-freemium/), TidBITS, checked 2026-11-07
5. [Almost half of users struggle with spreadsheet data (ThoughtSpot press release)](https://www.thoughtspot.com/press-releases/new-research-shows-almost-half-of-users-struggle-to-make-sense-of-data-in-spreadsheets), ThoughtSpot, checked 2026-11-07
6. [Why won't Numbers merge cells???](https://discussions.apple.com/thread/6033574), Apple Community, checked 2026-11-07