Numbers doesn't have a merge cells feature like Excel does

Numbers, Apple's spreadsheet app, does not include a built-in merge cells function. If you select multiple cells and look for a merge option in the menus, you won't find one. This is a deliberate design choice — Apple built Numbers around a different table structure than Excel, and merging cells doesn't fit that model.

If you need the visual effect of merged cells — text that spans across multiple columns or rows — you have three practical workarounds: make one cell much wider, use a text box positioned over the cells, or convert your spreadsheet to Excel format and merge there instead.

Key Takeaways

  • Numbers has no merge cells command because its table design works differently from Excel.
  • You can widen a single cell to span the visual width you need, then center the text inside it.
  • A text box placed over multiple cells gives the appearance of merged content without actually combining cells.
  • If merging is essential to your workflow, export the Numbers file to Excel format, merge there, and work in Excel going forward.
  • Merged cells in an Excel file will remain merged if you open that file in Numbers, but you cannot create new merged cells within Numbers itself.

Widening a single cell to span multiple columns

The simplest workaround is to make one cell wider and position it where you want the merged effect. Select the cell you want to expand, then drag the column border to the right until it covers the width of the columns you would have merged. The cell itself stays a single cell — it just takes up more horizontal space.

To center text across that wider cell, select it, go to the Format panel on the right, find the alignment options, and choose center. The text will sit in the middle of the expanded cell. This works well for headers or labels that need to span across a data section.

The limitation is that this only works for columns. If you need text to span down multiple rows, this approach won't give you the visual effect you're looking for.

Using a text box to cover multiple cells

A text box is a floating object that sits on top of your table rather than inside it. You can position a text box over any number of cells and type content into it, creating the visual appearance of merged cells without actually changing the table structure.

To add a text box, go to Insert in the menu bar, select Text Box, then click and drag on your spreadsheet to create the box. Type your content, then resize and position it to cover the cells you want. You can adjust the text size, color, and alignment using the Format panel.

Text boxes are useful when you want a header or label that visually spans rows and columns but doesn't need to interact with the data below it. The downside is that the text box is separate from the table, so if you move or resize the table later, the text box won't move with it.

Converting to Excel if merging is essential

If your workflow depends on merged cells — for example, if you're working with a template that requires them or collaborating with people who use Excel — the most straightforward solution is to export your Numbers file to Excel format and do your work there instead.

To export, open your Numbers spreadsheet, go to File in the menu bar, select Export, choose Excel, and save the file. Once it opens in Excel (or Numbers can open it again), you can select multiple cells and use the merge cells command. In Excel on Mac, that's Format > Cells > Alignment tab > Merge cells. On Windows, it's Home > Merge & Center.

After you merge cells in Excel, the file will display those merged cells correctly if you open it back in Numbers. You just cannot create new merged cells within Numbers itself.

Why Numbers doesn't have merge cells

Numbers uses a different underlying table structure than Excel. In Numbers, each cell is independent and maintains its own data and formatting. Merging cells would require breaking that independence, and Apple chose not to build that feature into the app.

This design choice makes Numbers simpler for many everyday spreadsheet tasks, but it does mean that some Excel workflows don't translate directly. If you frequently work with merged cells, you may find Excel a better fit for your needs.

Frequently Asked Questions

If I open an Excel file with merged cells in Numbers, will the cells stay merged?

Yes. Numbers can read and display merged cells from an Excel file. You just cannot create or edit merged cells within Numbers. If you need to change the merged cells, you would need to open the file in Excel.

Can I merge cells on iPad Numbers the same way as Mac?

Yes. iPad Numbers has the same limitations as Mac Numbers — no merge cells command. The workarounds (widening cells, using text boxes, or exporting to Excel) work the same way on both devices.

Does a text box in Numbers move if I resize the table?

No. Text boxes are separate objects that sit on top of the table. If you resize or move the table, the text box stays where you positioned it. You would need to move the text box manually to keep it aligned with the table.

What happens if I paste an Excel spreadsheet with merged cells into Numbers?

The merged cells will paste as merged cells and display correctly in Numbers. However, if you need to modify those merged cells or create new ones, you would need to work in Excel instead.