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

Numbers, Apple's spreadsheet app, does not have a built-in merge cells command. If you select multiple cells and look for a merge option in the Format menu, you will not find one. This is a deliberate design choice — Apple built Numbers around a different table structure than Excel, and merged cells work differently as a result.

If you need the visual effect of merged cells — text that spans across multiple columns or rows — you have three practical options: use a text box overlay, adjust column widths to create the appearance of a single cell, or restructure your table to avoid needing merged cells in the first place. Which approach works best depends on what you are actually trying to do with the data.

Key Takeaways

  • Numbers has no merge cells button; the feature does not exist in the app's design.
  • A text box placed over multiple cells creates the visual effect of a merged cell without breaking your data structure.
  • Widening a single column and centering text can look like a merged header without the technical problems merged cells create.
  • If you need true merged cells for compatibility with Excel, export your Numbers file to Excel format and merge there instead.
  • Restructuring your table to use separate rows or columns for headers often works better than trying to merge cells.

Using a text box to span across multiple cells

The simplest workaround is to place a text box on top of the cells you want to appear merged. On Mac, click Insert in the toolbar, then select Text Box. On iPad, tap the plus icon, then Text. Type your text, then drag the text box to position it over the cells you want it to cover. You can resize the box to span as many cells as you need.

This approach keeps your actual cell data intact — the cells underneath the text box still contain their original values and formulas. The text box is purely visual. If you later need to edit the cells below, you can click the text box and move it aside, or straightforward click directly on a cell to edit it. The text box stays on top but does not interfere with the spreadsheet's calculations.

Format the text box the same way you would format a cell: right-click it (or tap and hold on iPad), choose Format, and adjust the font, size, color, and alignment. You can also add a border or background color to make it look more like a cell. This method works well for headers, titles, or any text that needs to visually span multiple columns without actually merging the underlying data.

Widening a column to create a single-cell appearance

If you want a simpler visual effect without adding a text box, widen a single column to span the space where multiple columns would normally sit. Select the column by clicking its header, then drag the right edge of the column header to make it wider. Type your text in that cell and center it. From a distance, it looks like a merged cell, but it is actually just one wide cell.

This works best for headers or titles at the top of a table. It does not work if you need data in the columns that appear to be merged — you are actually just hiding or removing those columns. If you do this, make sure the columns you are widening do not contain data you need elsewhere in the spreadsheet.

Restructuring your table to avoid merged cells

Many situations that seem to require merged cells can be solved by rethinking the table layout. Instead of merging cells across multiple columns for a header, create a separate row above your data table and use that row for your header. Instead of merging cells down a column, use a single cell with line breaks (press Control+Enter on Mac, or Shift+Enter on iPad) to add multiple lines of text within one cell.

This approach keeps your data cleaner and makes it easier to sort, filter, or export your spreadsheet later. Numbers handles single cells with wrapped text better than it handles merged cells, and your file will be more compatible with other spreadsheet apps if you ever need to move it to Excel or Google Sheets.

Converting to Excel if you need true merged cells

If you absolutely need merged cells and plan to use the file in Excel, export your Numbers spreadsheet to Excel format first. On Mac, click File, then Export, and choose Excel. On iPad, tap the three dots, then Export, and select Excel. Open the exported file in Excel on your Mac or in the web version at Office.com, then use Excel's merge cells feature as normal.

Keep in mind that merged cells in Excel can cause problems with sorting and filtering, and they are generally considered poor spreadsheet design. If someone else will be using your file, or if you plan to do complex data work with it later, avoid merging cells even in Excel. A well-structured table without merged cells is easier for others to work with and less likely to cause errors.

Why Numbers does not have merge cells

Numbers was designed from the ground up as a different kind of spreadsheet than Excel. Excel treats a spreadsheet as a grid where any cells can be merged, which can create problems: merged cells break sorting, make filtering unpredictable, and complicate formulas. Numbers avoids this by not allowing merges in the first place, pushing users toward cleaner table structures.

This is not a limitation you are stuck with — it is a design philosophy. If you find yourself wanting to merge cells frequently, it often means your table structure could be clearer. Separate headers into their own rows, use single cells with wrapped text, or use text boxes for visual effects. Your spreadsheet will be easier to read, easier to update, and easier to share with others.

Frequently Asked Questions

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

No merge cells feature exists on either platform — Numbers does not have this function on Mac, iPad, or iPhone. The workarounds (text boxes, wide columns, restructuring) work the same way on all devices.

If I open an Excel file with merged cells in Numbers, what happens?

Numbers imports the file but does not preserve the merged cells. The cells separate back into individual cells, and the text from the merged cell appears in the top-left cell of the range. You may need to reformat the table after opening it in Numbers.

Will a text box I create in Numbers stay in place if I export to Excel?

Text boxes export as separate objects in Excel, not as merged cells. They will appear on top of your spreadsheet, but they are not tied to specific cells. If someone moves or deletes rows and columns in Excel, the text box may no longer align with the data below it.

Is there a keyboard shortcut to merge cells in Numbers?

No. Numbers does not have a merge cells command, so there is no keyboard shortcut. The feature does not exist in the app at any level.