Find and Unmerge Merged Cells in Excel: Step-by-Step

How-to basics · Updated November 20, 2026

To find and unmerge cells in Excel for Microsoft 365 on Windows, open Find with Ctrl+F, choose Options > Format > Alignment, check Merge cells, and select Find All. Review the matches, select the merged cells you want to fix, then choose Home > Merge & Center ▼ > Unmerge Cells. Before you unmerge, remember that Excel keeps the value in the upper-left cell of each merged area; the other cells stay blank.

This method is useful when merged cells are scattered through a worksheet and difficult to spot by eye. You need a desktop version of Excel for the format-search steps below. Save a copy first if the worksheet contains important data or complicated layouts.

What You’ll Need

  • The workbook open in the desktop version of Excel for Microsoft 365 on Windows. Format-based Find options may not be available in Excel for the web.
  • Permission to edit the worksheet. If it is protected, you may need the password or help from the workbook owner before you can unmerge cells.
  • A moment to check what information is stored in merged areas. Unmerging does not copy the visible text into every newly separated cell.

Step-by-Step

  1. Save a working copy. Choose File > Save As and save a separate copy if you are unsure how the sheet will look after unmerging. You can also use Ctrl+Z immediately after an accidental change, but a saved copy is safer for a large or important workbook. If the file is shared, check that you are editing the intended copy.
  2. Open Find and prepare the search. Press Ctrl+F to open the Find and Replace dialog. Select Options to show the extra search settings if they are hidden. The Find what box can be blank for a format-only search. If the dialog is carrying old criteria from an earlier search, clear them before setting the merged-cell format so they do not narrow your results unexpectedly.
  3. Set the search format to merged cells. In the Find dialog, choose Format. In the Find Format window, open the Alignment tab and check the Merge cells box. Confirm with OK to return to Find. If other format properties are also set in the search, clear the format criteria and set Merge cells again by itself; otherwise Excel may look for cells matching several formatting details instead of all merged cells.
  4. Search the current worksheet. In the Find dialog, check that Within is set to Sheet, then choose Find All. Excel displays matching cell references in a results list. If the list is empty, do not assume the workbook has no merged cells yet: check the troubleshooting section for search criteria, worksheet scope, and version issues.
  5. Review the matches before changing anything. Click a result to jump to that merged area on the worksheet. Check its location and purpose, especially if the sheet has headings, print layouts, or grouped sections. The results list can help you move through matches one by one. If you want to unmerge every match, make sure the results are all on the intended worksheet and that the layout can tolerate the change.
  6. Select the matches you intend to unmerge. In some desktop Excel versions, you can click in the Find All results list and press Ctrl+A to select the found cells, then close the dialog and verify the highlighted selection. If that shortcut selects text in the dialog instead, or if you only want some results, use the list to visit and select the relevant cells individually. Do not proceed unless the worksheet shows the intended merged areas as selected. You can also close Find and use the search results as a checklist, selecting each area directly.
  7. Unmerge the selected cells. On the Home tab, open the dropdown beside Merge & Center and choose Unmerge Cells. The selected merged areas become separate cells. The command does not delete the value retained in the upper-left cell, but it does not fill the newly separated cells with that value either. If the selection includes ordinary unmerged cells, Excel leaves those cells as they are.
  8. Check the result and repeat if needed. Inspect the changed areas for shifted-looking headings, blank cells, or text that now appears to sit at the left of a larger range. If you searched one sheet at a time, repeat the format search on other worksheets as needed. The Within setting applies to the current sheet, so do not assume Find All scanned every sheet in the workbook.
  9. Clear the search format when finished. Reopen Find and use the Format dropdown’s Clear Find Format option if it is available, or clear the criteria in the Find Format window. This prevents an old merged-cell format condition from affecting a later search. Save the workbook when you are satisfied with the result.

Mac and web note: In Excel for Mac, Command+F opens Find; the dialog and ribbon arrangement can differ from Windows, but look for the Find format options and the Merge cells setting if your version provides them. On either desktop platform, the unmerge command is on the Home tab in the Merge & Center dropdown. Excel for the web may not offer the same format-based Find controls. If you cannot set a Find format there, open the workbook in the desktop app and use the steps above.

Common Mistakes

  • Expecting the value to fill every cell: Unmerging only separates the range. Excel retains the content from the upper-left cell of each merged area; the rest of the cells are blank. If you need repeated labels, fill them deliberately after checking which cells should contain data.
  • Searching for a word instead of the merge format: A text search finds matching content, not every merged cell. A merged area may be empty, contain a date, or have text that differs from the search word. Use the Merge cells format criterion to find the layout feature itself.
  • Leaving old Find formatting in place: Find can remember format settings from earlier searches. Those settings can make a new search return fewer matches or none. Clear the old Find format before building the merged-cell search.
  • Assuming Find All searches every worksheet: With Within set to Sheet, Excel searches the active worksheet. Visit each relevant sheet and run the search again, or use an appropriate workbook-wide search setting if your Find dialog offers it.
  • Unmerging without checking the selection: A large selection may contain merged areas you meant to keep, particularly when search results are selected in bulk. Verify the highlighted cells before choosing Unmerge Cells.
  • Confusing unmerge with restoring deleted data: If values in cells were overwritten when a range was originally merged, unmerging will not bring them back. Undo may help immediately after the merge, but otherwise use a prior version or backup.

Tips

  • Work on a copy when the sheet is a template. Merged cells are often used to format report titles and section labels. A copy lets you compare the original appearance and undo layout changes without affecting the source.
  • Use the results as a review list. A Find All list makes it easier to locate non-adjacent merged areas than scrolling through a long sheet. Check each match in context instead of unmerging everything automatically.
  • Consider whether unmerging is really necessary. If the goal is simply to center a heading across columns, unmerge it and try Home > Alignment settings such as Center Across Selection where suitable. That alignment option centers text across selected cells without merging them. Check the final appearance before applying it to a whole report.
  • Watch for merged ranges that span rows. A merged block can cover multiple columns, multiple rows, or both. After unmerging, inspect the surrounding row heights, column widths, borders, and alignment; those formatting choices can remain and may make the separate cells look unusual.
  • Keep a record of important labels. Before unmerging a complex layout, note which label belongs to which range. Since only the upper-left cell holds the original content after unmerging, this helps you decide where to enter headings or repeat values afterward.
  • Use Undo promptly if the outcome is wrong. Ctrl+Z on Windows or Command+Z on Mac reverses a recent unmerge, provided you have not closed the workbook or undone other necessary steps. For changes made earlier or in a shared file, a saved copy or version history may be more useful.

Troubleshooting

Find All returns no results. Reopen Options and confirm the format criteria are set to Merge cells. Clear any text in Find what if you intended a format-only search, and clear extra formatting requirements. Verify that Within is set to Sheet and that the correct worksheet is active. Then run Find All again. If the worksheet is protected, address that restriction before trying to change cells.

The Format button or Merge cells option is missing. Make sure you are using the desktop Excel app rather than Excel for the web, and expand the Find dialog with Options if necessary. On Mac, controls may be arranged differently and can depend on the Excel version. If your version does not expose format-based Find, use a desktop version that does, or inspect the sheet manually; do not rely on an ordinary text search to identify every merged area.

Clicking a result does not select all matches. Find All can show many results without leaving all of them selected at once. Click a result to go to that cell and inspect it. If bulk selection does not work in your dialog, select and unmerge one result at a time, checking each area as you go. This takes longer but avoids applying the command to an unintended range.

Unmerge Cells is unavailable or does nothing. Confirm that the active selection includes a merged cell, then open the dropdown beside Merge & Center rather than clicking the main button. If the worksheet is protected, Excel may prevent the change until protection is removed by someone authorized to do so. Also check whether the workbook is open in a mode that restricts editing.

The layout looks different after unmerging. This is expected: separate cells no longer behave like one wide or tall cell, and the retained value remains only in the upper-left cell. Adjust alignment, borders, row height, or column width as needed. If you need the same label in several cells, enter or copy it intentionally after confirming that doing so will not overwrite existing information.

You need the previous contents back. Unmerge cannot restore values that were lost during an earlier merge. If the merge or unmerge just happened, use Undo. Otherwise, check a backup, a saved earlier copy, or the workbook’s available version history. Avoid entering guessed values into blank cells if the original data matters.

Frequently Asked Questions

Can Excel find all merged cells in a worksheet?

Yes. In desktop Excel, use Find’s format criteria, set Alignment to Merge cells, and choose Find All. Review the matches before changing them. Search the other worksheets separately if you need to check the whole workbook.

Does unmerging delete the text in a merged cell?

Usually, the text remains in the upper-left cell of the merged area. The other cells become separate and are blank. Unmerging does not copy the text across the range or recover contents that were overwritten before the unmerge.

Can I unmerge many cells at once?

Yes, if you can select the intended matching cells together. Find All may let you select its results as a group in desktop Excel, but behavior can vary with the dialog and version. Verify the worksheet selection first; otherwise, unmerge each match individually.

Can I find merged cells in Excel for the web?

The web app may not provide the desktop Find dialog’s format-search controls. If you cannot choose a Merge cells search format, open the workbook in desktop Excel to locate merged cells with Find All. Do not mistake a text search for a complete merged-cell search.

Will unmerging change the data in other cells?

Unmerge separates the selected merged areas and leaves their non-upper-left cells blank; it does not populate them with the retained value. Check the cells and your selection carefully, especially in a worksheet where the layout uses merged ranges to organize information.

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.