How to Unmerge Cells in Excel and Keep Data

How-to basics · Updated November 20, 2026

To unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell or range, then choose Home > Merge & Center arrow > Unmerge Cells. Excel keeps the value in the merged area’s upper-left cell and makes the other cells blank. If you want that value repeated in the newly separate cells, fill them after unmerging. If other values were removed when the cells were originally merged, unmerging cannot restore them; you will need Undo, a backup, or version history.

What You’ll Need

  • The Excel workbook containing the merged cells. Save a copy first if the workbook is important or the affected area is large.
  • A clear idea of whether the value should stay only in the first cell or be repeated in the other cells.
  • If you are trying to recover content removed during an earlier merge, access to Undo, a saved copy, or the workbook’s version history.

Step-by-Step

  1. Check the affected area. Open the worksheet and click a merged cell. Excel selects the full merged area, even if you clicked near its edge. Check the formula bar to see the value currently stored there; it will normally be the value from the area’s upper-left cell. If you see several merged areas, note where each one starts and ends so you can handle them separately.
  2. Make a safety copy if needed. Use File > Save As to create a separate copy before making many changes. This is especially useful when you are working on a shared, imported, or business-critical workbook. Unmerging is usually straightforward, but filling cells afterward can overwrite content if you select too broad a range.
  3. Select the merged cell or cells. Click one merged cell to unmerge just that area. To unmerge several areas at once, drag across a range containing them, or select a larger worksheet range. Excel will unmerge any merged cells within that selection; ordinary, unmerged cells remain separate. If you are unsure which cells are merged, select the relevant area and inspect the Merge & Center control on the Home tab.
  4. Unmerge the selection. On Windows, go to Home > Merge & Center and open its drop-down arrow, then choose Unmerge Cells. The merged area becomes individual cells. Excel keeps the existing content in the top-left cell of each formerly merged area and leaves the other cells empty. Unmerging does not automatically copy the value into the newly opened cells.
  5. Decide what the empty cells should contain. If the value is a heading that should appear only once, leave the other cells blank. If it is a label that should repeat on every row or column, fill only that former merged area. For a vertical merged area, select the whole unmerged range from its top cell to its bottom cell, then choose Home > Fill > Down. Excel copies the top cell’s content down the selected range. For a horizontal area, select from the leftmost cell through the rightmost cell and choose Home > Fill > Right. Check the result before moving on.
  6. Repeat carefully for other merged areas. If the sheet has multiple merged blocks with different values, unmerge and fill each block separately. Do not select a large section and fill it all down or right unless every cell in that selection should repeat the same starting value. For example, if A1:B1 is a heading and A2:B2 is a different heading, filling the combined area right or down can copy the wrong value into part of the sheet.
  7. Review and save. Scan the affected rows and columns for unexpected blanks, repeated labels, or changed formatting. Click a few cells and check the formula bar if you need to confirm that values are in the intended positions. When the result looks right, save the workbook. If the sheet is shared, make sure you are editing the intended file and not a local or outdated copy.

On Mac: The ribbon command is also on the Home tab; open the Merge & Center menu and choose Unmerge Cells. In Excel for the web, select the merged cell and use the Home tab’s Merge & Center menu to find the unmerge option. The ribbon can look slightly different by platform or window size, but the command has the same effect.

Common Mistakes

  • Expecting unmerge to restore every previous value. A merged cell can hold only one value. When cells are merged, Excel retains the upper-left cell’s content and discards content from the other cells in that merged area. Unmerging separates the cells but cannot bring discarded values back.
  • Filling every blank without checking the layout. A blank after unmerging might be intended to stay blank. Repeating a heading into every cell can make sorting, filtering, or later data entry harder. Fill only when the repeated value is actually needed.
  • Filling across multiple blocks at once. Each merged area may have its own label. Applying Fill Down or Fill Right to a selection containing several blocks can spread one label into unrelated cells. Work block by block.
  • Confusing unmerge with clearing cells. The Unmerge Cells command separates cells; it does not mean Clear Contents. Conversely, pressing Delete or using Clear Contents removes the selected cell’s value and is not a way to unmerge.
  • Overlooking formulas or formatting. The retained top-left content may be a formula rather than a typed value. Filling that cell down can create adjusted formulas, which may or may not be wanted. Inspect the formula bar and check borders, alignment, and number formats after unmerging.

Tips

  • Use Undo immediately if the merge just happened. If you merged the cells moments ago and Excel is still in the same editing session, press Ctrl+Z on Windows or Command+Z on Mac. Undoing the merge can restore the pre-merge state, including values that were in the other cells. Avoid making unrelated changes first if you need to undo a specific action.
  • Use Center Across Selection for future headings. If you want a heading to look centered over several columns without merging those cells, select the range, open the Format Cells dialog, choose the Alignment tab, and set Horizontal to Center Across Selection. This keeps the cells separate, which is generally easier for sorting and working with tables.
  • Keep headings separate from data tables. Merged cells can interfere with sorting, filtering, copying, and some formulas. Where possible, keep merged formatting in a title area above the table rather than inside the rows and columns that hold records.
  • Use version history when the loss happened earlier. For a workbook stored in OneDrive or SharePoint, open its version history and inspect a version from before the merge. Save a recovered version separately or copy the missing values into the current workbook after checking that they belong there.
  • Check before filling. Select one former merged area at a time and confirm the top-left value is the one you intend to repeat. The Fill commands copy the starting cell’s content, so a wrong starting cell produces a wrong result across the selection.

Troubleshooting

Unmerge Cells is unavailable or does not seem to do anything: Click a cell in the merged area first and confirm that the intended worksheet is active. If the worksheet is protected, unmerging may be blocked; check Review > Unprotect Sheet. You may need the sheet password or permission from its owner. In a shared workbook or a restricted file, editing permissions can also prevent changes.

The cells separate, but the other cells are blank: That is normal. Excel preserves only the upper-left value in a merged area. If you want repeated labels, use Fill Down or Fill Right on that single area. If you expected different values in those cells, look for a pre-merge workbook version, use Undo if available, or check a backup. Do not assume that blank cells still contain hidden data.

The wrong value appears after filling: Undo the fill with Ctrl+Z on Windows or Command+Z on Mac, then select only the intended former merged block. Check that its first cell contains the right value before choosing Fill Down or Fill Right. If you have already made many other edits, inspect the workbook carefully before undoing a sequence of actions.

Some cells remain merged: The selection may not have covered every merged block, or the sheet may contain merged cells outside the selected range. Select the remaining area and use Home > Merge & Center > Unmerge Cells again. If a command is hidden because the ribbon is narrow, maximize the window or open the Merge & Center drop-down.

You need values that were lost when the cells were merged: Unmerge cannot reconstruct discarded content. Try Undo if the merge is the most recent action. Otherwise, check File > Info > Version History for a OneDrive or SharePoint file, or restore from a backup. You can also check whether the original data exists in another sheet, exported file, or source system.

Frequently Asked Questions

Does unmerging cells delete the value?
Normally, no. Excel leaves the merged area’s value in its upper-left cell and makes the other cells separate and blank. If you want the value repeated, fill the cells after unmerging.

Can I unmerge cells and keep the value in every cell?
Yes, if you mean repeating the value that remains in the upper-left cell. Unmerge the area, select that single former merged range, and use Home > Fill > Down for a vertical range or Home > Fill > Right for a horizontal range. This will not recover different values removed during the original merge.

Can I recover data that disappeared when I merged cells?
Only if it is still available through Undo, a backup, or an earlier workbook version. Excel does not store the overwritten cell contents inside the merged cell for later recovery. For OneDrive or SharePoint files, check version history; for other files, look for a saved copy or source data.

Can I unmerge multiple cells at once?
Yes. Select a range containing the merged areas, then choose Home > Merge & Center > Unmerge Cells. The command affects merged cells in the selection. If you plan to fill values afterward, handle each block separately so different labels do not get mixed.

Will unmerging change the formatting?
It separates the cells and may leave formatting applied across the individual cells, such as borders, alignment, or fill. Review the area afterward and adjust formatting if needed. Unmerging does not automatically restore separate formatting that existed before the cells were merged.

Is there a keyboard shortcut to unmerge cells?
There is no single dedicated unmerge shortcut that works consistently across Excel versions and platforms. Use the Merge & Center menu on the Home tab. If you rely on ribbon key tips on Windows, the key sequence can vary, so confirm the letters shown in your Excel window rather than assuming one sequence.

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.