Unmerge Cells in Excel on iPad: Steps, Limits, and Fixes

How-to basics · Updated November 20, 2026

Yes. In Excel on iPad, tap a merged cell, open the Home tab, and choose Merge & Center > Unmerge Cells. If the command is not immediately visible, look for the Merge & Center menu or its drop-down in the Home tab’s alignment controls; the ribbon layout can vary with the app version and screen size.

Unmerge a cell step by step

Unmerging separates one merged area back into its individual worksheet cells. You usually only need to select a cell inside the merged area; you do not have to recreate the original range first. Use these steps:

  1. Open the workbook in the Excel app on your iPad and switch to the worksheet containing the merged cell.
  2. Tap the merged cell. If you are unsure which cells it covers, look at the column letters and row numbers around it, or tap the cell and inspect the selection outline.
  3. Tap Home on the ribbon. If the ribbon is collapsed, tap the Home tab or expand the ribbon controls.
  4. Open Merge & Center in the alignment controls, then tap Unmerge Cells. In some layouts, you may need to tap the small arrow or menu beside the command to see the options.
  5. Check that the separate cell boundaries have returned and that the value or formula is where you expect it.

The wording or placement may differ slightly as Microsoft updates Excel. The key is to select the merged area and find the unmerge option in the Home tab’s merge controls. If you see only a merge command, open its menu rather than tapping a different formatting tool.

What unmerging does to the cells and their contents

A merge makes a selected rectangular range appear as one larger cell. Excel keeps the content in the upper-left cell of that range. If other cells contain data, Excel generally warns that merging keeps only the upper-left value and removes the other contents if you continue. Unmerging does not bring those discarded values back: it restores the separate cell boundaries, but the cells that had no retained content are normally blank.

For example, suppose A1 contains a heading and B1 is blank, and you merge A1:B1. After unmerging, A1 contains the heading and B1 is available as a separate cell again. If A1 and B1 both had text before the merge, unmerging will not reliably restore both texts. Do not treat unmerge as a recovery tool for data that was overwritten during a merge.

The retained value or formula remains in the upper-left cell. The appearance may change because a merged cell’s alignment and borders no longer describe one large area. Cell formatting can remain on individual cells, so check fills, borders, alignment, and number formats after separating the range. If the result looks untidy, select the affected cells and adjust their formatting separately.

Before you unmerge: protect important data

If you are not sure what is in the cells that were combined, save a copy of the workbook or use Undo immediately if the merge was just performed. A quick check of the formula bar can help reveal the content of the selected merged cell, but it cannot show values that were already removed from the other cells by an earlier merge.

For a workbook you did not create, ask whether the merged area is intended as a heading or report layout before changing it. If the worksheet is shared, an unmerge changes the sheet for other people who use that workbook. A copy is especially useful before changing a template, a shared report, or a sheet with carefully arranged formatting.

Also check whether formulas or instructions refer to the merged area. A formula that points to the upper-left cell may continue to work, but a layout change can affect users who expect a label to span several columns. If your goal is only to make text easier to read, consider whether wrapping or alignment changes would solve the problem without altering the cell structure.

Unmerge several merged areas

You can apply the unmerge command to a larger selection when it contains more than one merged area. On iPad, select the range that covers the merged cells, then use Home > Merge & Center > Unmerge Cells. Excel can unmerge merged cells included in the selection. Since touch selection is less precise than using a mouse, take care not to include unrelated parts of the sheet whose layout you want to preserve.

If the ranges are far apart, it may be safer to unmerge them one at a time. After each change, check the worksheet before continuing. This makes it easier to spot whether you selected the intended merged cell and reduces the chance of altering a large table by mistake. If a selection is difficult to make on the iPad screen, zoom in or rotate the device to landscape orientation.

Why Unmerge Cells may be unavailable

If the option is missing, greyed out, or does not seem to change the sheet, check these common causes:

  • The wrong cell is selected. Tap directly inside the merged area. A nearby cell may look like part of the same heading but be a separate cell.
  • The workbook is read-only. If Excel opened it in viewing mode, you may need editing permission or to open an editable copy before changing the worksheet.
  • The sheet is protected. Protection can prevent changes to cell layout. If you are authorized, use the workbook’s sheet-protection controls to remove protection; a password may be required. Ask the workbook owner rather than trying to bypass protection.
  • The ribbon is compact. On a smaller display or in a narrow window, some controls may be hidden in a menu. Expand the ribbon or open the Merge & Center options.
  • You are in another app or viewer. A file preview or a third-party spreadsheet app may not provide Excel’s editing controls. Open the workbook in Excel itself.

If the app appears out of date, updating Excel from the App Store may provide the current interface and fixes. If the workbook is stored online, confirm that it has finished opening and that you have permission to edit it. A missing command is not necessarily evidence that the worksheet is damaged.

Unmerging versus changing alignment

Sometimes people want to unmerge because a heading should look centered across columns, or because sorting and filtering a table is difficult. Merging cells is mainly a layout choice, and merged cells can complicate selecting, sorting, filling, or working with rectangular data ranges. In a data table, it is usually more practical to keep one value per cell and use a separate heading row or formatting to show the section title.

If you only need text to appear centered over a range, Excel for Windows has a Center Across Selection alignment option that can provide a similar visual result without merging the cells. That option is not the same as merging and may not be available in the same way in Excel for iPad. On the iPad, you can instead keep the cells separate and use ordinary alignment, text wrapping, or a dedicated heading cell, depending on the layout you need.

For a workbook that will be edited on different devices, a simple unmerged grid is generally easier to maintain. This is particularly true for lists and tables where each row represents a record. Merges are more appropriate for presentation areas, such as a report title, where the spanning appearance matters more than sorting or entering data into each underlying cell.

Using Excel on iPad compared with other versions

The basic result is the same across Excel versions: unmerging restores individual cells, and it does not recover content that was discarded when cells were merged. On Excel for Windows, the command is available from Home > Merge & Center > Unmerge Cells. Excel for Mac also provides an unmerge option from its Home tab’s merge controls. Excel for the web has merge controls in its ribbon as well.

What differs most on iPad is how you reach the command. Touch controls may be condensed, and a menu can replace the wider desktop ribbon. If instructions written for a computer say to right-click a cell or use a ribbon group that is not visible, look for the corresponding Home-tab menu instead. A keyboard attached to an iPad can help with navigation, but tapping the cell and using the ribbon is the straightforward method.

After unmerging: check the worksheet

Once the merge is removed, review the surrounding rows and columns rather than checking only the selected cell. A heading that used to span several columns may now sit at the left edge of the range, and text may no longer fit in its original column. You may need to widen a column, wrap text, change alignment, or add a border to make the layout readable.

If you unmerged the wrong area, use Excel’s Undo control promptly, before making unrelated edits. Undo is intended to reverse recent actions, but it is not a substitute for a saved copy, especially when the workbook is shared or you have continued editing. Confirm the result before saving or closing the workbook.

Frequently Asked Questions

Can I unmerge cells in Excel on iPad?
Yes. Select a merged cell, then use Home > Merge & Center > Unmerge Cells. The menu’s exact appearance can vary with the app layout.

Will unmerging restore the text from every original cell?
No. Excel retains the upper-left cell’s content when cells are merged. Unmerging restores the separate cells but does not recover other content removed during the merge.

Can I unmerge cells without losing the value that is visible?
Yes. The visible value or formula remains in the upper-left cell of the merged range. Check that cell after unmerging, particularly if the range covers several rows or columns.

Why is Unmerge Cells greyed out?
Check that you selected a merged cell and that the workbook is editable. Sheet protection or read-only access can block changes. If protection is intentional, ask the owner for permission or the required password.

Can I unmerge multiple cells at once on iPad?
You can select a range containing multiple merged areas and apply the unmerge command. Because selecting a large range with touch can be imprecise, unmerge separate areas one by one when you need to preserve nearby layout.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.