Learn how to merge cells in the Apple Numbers app on your iPhone, iPad, and Mac to combine multiple columns, rows, or adjacent cells into one.
Merging cells gives you flexibility in terms of formatting your spreadsheets. For example, you may want to convert multiple adjacent cells into one larger cell. Or, maybe you’d like to merge several rows or columns into one.
Apple’s free Numbers app, which is preinstalled on the iPhone, iPad, and Mac, makes it easy to merge multiple cells together, so follow along as we show you how it’s done.
Merge cells in Numbers for Mac
- Launch the Numbers app on your Mac and open your spreadsheet.
- Select the adjacent cells by clicking the first cell and dragging through the rest (or hold the Shift key and click the last cell).
- Then click Table > Merge Cells from the top menu bar.
You can also hold the Control key while clicking the selected cells and choose Merge Cells in the menu.
To unmerge merged cells, select them and follow the steps above, but choose Unmerge Cells instead.
Merge cells in Numbers for iPhone and iPad
- Open Numbers on your iPhone or iPad and go to your spreadsheet.
- Select adjacent cells by touching the first cell and dragging to select a range.
- Tap the green Cell actions button at the bottom and choose Merge Cells.
To unmerge cells in Numbers for iPhone and iPad, select the merged cell and follow the steps above, but choose Unmerge Cell instead.
Do more with Numbers…
Numbers is part of Apple’s free iWork productivity suite, comprising the word processor Pages, the presentation software Keynote, and the spreadsheet app Numbers. The latter is a more than capable replacement for Microsoft Excel.
Numbers lets you go beyond simple spreadsheets with checkboxes, sliders, and star ratings.
You can insert other live-updated items into the spreadsheet. For example, you can easily insert and format the current date and time in Numbers. We also have a tutorial showing how to work with shapes and lines in the iWork apps.
Are there any other tips or tricks for Apple Numbers that you need help with? If so, let us know by leaving a comment below.