Unmerge Cells in Excel on iPad: Step-by-Step

How-to basics · Updated November 20, 2026

To unmerge cells in Excel on an iPad, tap the merged cell, open the Home tab, tap Merge & Center, and choose Unmerge Cells. The cell becomes a group of separate cells again; the value or formula in the merged area stays in its upper-left cell, while the other cells are blank. Before you start, check that this is the workbook and cell you mean to change.

What You’ll Need

  • An iPad with the Microsoft Excel app installed and the workbook open.
  • Permission to edit the workbook. A read-only file or protected sheet may prevent changes.
  • The merged cell or merged range you want to separate. If you are unsure what it contains, inspect the selected cell or make a copy of the workbook first.

You do not need to install an add-in or use a formula. The change is made with Excel’s built-in cell-formatting command. The names and placement of ribbon controls can vary slightly with the app version and screen layout, but the command is on the Home ribbon.

Step-by-Step

  1. Open the workbook in Excel. Find the file in Excel or open it from its saved location. If it opens in viewing mode, switch to editing if that option is available. If you cannot edit the file, ask its owner for editing access or an editable copy before trying to change the cell.
  2. Go to the worksheet with the merged cell. Use the sheet tabs at the bottom of the workbook to move between worksheets. If the sheet is wide or long, scroll to the relevant area. A merged cell may look wider or taller than its neighbors because it covers several ordinary grid cells.
  3. Tap the merged cell once to select it. Look for the selection outline and the active-cell indicator. Tap inside the visible merged area, not just beside it. If the selection lands on a neighboring cell, tap again in the center of the merged area. You can also use the name box, if visible, to go to a known address; for example, a merge across B2:D2 is selected by tapping anywhere in that displayed area.
  4. Check the cell’s contents before changing it. With the merged cell selected, look at the formula bar or the cell itself. If its text is cut off, the formula bar can make it easier to review the full entry. This is a useful precaution if the value is important: unmerging will not restore values that were discarded when the cells were originally merged. If you need a separate copy of the text or formula, copy it somewhere safe before continuing.
  5. Open the Home ribbon. Tap Home in the ribbon tabs if it is not already selected. Find Merge & Center, usually in the alignment controls. On a compact layout, you may need to scroll across the Home command strip or open its additional commands to find it. Keep the merged cell selected while you do this.
  6. Open the merge options. Tap the arrow or menu associated with Merge & Center. In the list of merge commands, tap Unmerge Cells. If tapping the main button immediately changes the cell rather than showing a list, use its menu arrow or the related command menu instead, if shown.
  7. Confirm that the cells are separate. Tap one of the formerly merged cells and check that the selection outline now fits an individual grid cell. The surrounding grid boundaries should also make it possible to select each cell separately. The original content should remain in the upper-left cell of the former merged range; neighboring cells will be empty unless you enter new content.
  8. Save or wait for the workbook to sync. Excel may save changes automatically when the workbook is stored online. Give it time to finish syncing and check for a save or sync indicator if one is displayed. For a file stored locally, use the available save control. If the workbook is shared, allow the update to finish before closing Excel.

Example: Suppose the merged area is B2:D2 and displays the heading “Quarterly Results.” After you unmerge it, B2 retains “Quarterly Results.” C2 and D2 become separate empty cells. You can then type different labels into C2 and D2, or leave them blank. Unmerging does not automatically copy the heading into all three cells.

Common Mistakes

  • Expecting the old contents to come back. If B2, C2, and D2 each held text before they were merged, Excel typically kept only the upper-left cell’s content during the merge. Unmerging separates the cells but does not recover the other entries. Look for an earlier workbook version or use Undo immediately after an unintended merge if you need to recover them.
  • Selecting the cell beside the merged area. A merged area can span multiple columns or rows, so its visible boundaries may not match a single grid cell. Confirm the selection outline is around the area you intend to change before opening the merge menu.
  • Choosing a different merge command. Options such as Merge & Center or Merge Cells combine cells; they do not separate them. Select the explicit Unmerge Cells command.
  • Assuming the formatting will reset. Unmerge changes the cell structure, not necessarily every appearance setting. Alignment, borders, fills, or wrapping may still look unusual afterward. Adjust those separately only if the result needs tidying.
  • Selecting only part of a merged area. If you are working with a selection rather than tapping one merged cell, make sure the selection includes the complete merged area. For a sheet with several different merges, handle them one at a time to avoid changing an unintended range.

Tips

  • Make a safety copy for important sheets. Before changing a form, report, or shared template, duplicate the workbook or worksheet if your workflow allows it. That gives you a reference if the layout needs to be restored.
  • Use the formula bar to review long entries. A narrow iPad screen can hide some of a cell’s displayed text. Checking the formula bar first helps you see what the selected cell contains before you alter its layout.
  • Unmerge only the area you need. If one heading is merged across several columns, there is no need to select a large section of the worksheet. A precise selection reduces the chance of changing other merged headings or labels.
  • Consider “Center Across Selection” for a heading. If your goal is simply to center a heading over several columns, merging is not the only layout choice. Excel for iPad may not provide every desktop alignment option, so check the available ribbon commands in your app. If the alternative is not available there, you can leave the cells unmerged and center the text using the options that are available, or adjust the layout later in desktop Excel.
  • Check how the sheet behaves after the change. Unmerged cells can make it easier to sort, filter, select individual values, or enter data into separate columns. Review nearby headings and borders afterward so the change still makes sense for the way the worksheet is used.

Troubleshooting

“Unmerge Cells” is missing or unavailable. First tap the merged area itself and check that it is selected. The command may be absent or disabled if the active cell is not merged. If the selection is correct, check whether the worksheet is protected or the workbook is read-only. You may need the owner to provide editing access or remove sheet protection; a password may be required. Also make sure you are on the Home tab and have opened the merge options rather than tapping a different alignment command.

The ribbon does not show “Merge & Center.” Confirm that the Home tab is selected. On a compact ribbon, controls can be off-screen, so swipe across the command strip or open the additional-command menu if your version shows one. If the app is out of date, update Excel through the App Store, then reopen the workbook and check again. The exact control placement can differ between app versions.

The wrong cells changed. If you have not made other edits since the change, tap Undo in Excel’s toolbar immediately. Undo can reverse the unmerge, but avoid making unrelated edits first because that makes it harder to undo only the intended action. Then select the correct merged area and repeat the steps. If Undo is no longer available, close without saving only if you are certain you can discard all other changes made since the last save; otherwise restore a prior copy or version if available.

The cells separated, but the text is not where expected. Check the upper-left cell of the former merged range. That is where Excel keeps the content. If the text appears missing, select that cell and inspect the formula bar. If the value was already lost during the original merge, unmerging cannot recreate it; check workbook version history, a backup, or another source for the missing information.

The result looks uneven. This is usually a formatting issue rather than a failed unmerge. Select the individual cells and review alignment, wrapping, row height, borders, and fill. Change only the settings that need adjustment. If the layout is complex, compare it with a saved copy before making more formatting changes.

Frequently Asked Questions

Does unmerging delete the text in the cell?
Usually, no. The value or formula remains in the upper-left cell of the former merged range. The other cells become separate and blank. Check the formula bar if the content is not visible in the cell.

Can I unmerge several merged cells at once on iPad?
You can try selecting a range that includes the complete merged areas and using Unmerge Cells, but the result depends on the selection and how the areas are arranged. For a mixed or important layout, unmerge each area individually and check it before moving on.

Will unmerging restore data that was there before the cells were merged?
No. Excel does not reconstruct values removed when cells were merged. Look for an earlier file version, backup, or source data. If you just merged the cells by mistake and have not continued editing, use Undo promptly.

Can I unmerge cells in a protected worksheet?
Not unless you have permission to change the sheet. Ask the workbook owner to unprotect it or provide an editable copy. If protection uses a password, you will need the password or help from the owner.

Does unmerging remove the cell’s formatting?
Unmerging separates the cells, but it may not reset all formatting. Check alignment, borders, fills, and text wrapping afterward, and change only what looks wrong.

Can I do this without the Excel app?
This guide uses Excel for iPad. If you open the workbook in another spreadsheet app or in a browser, the ribbon and command names may differ. Use Excel if you want to follow the steps as written.

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.