To unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell or range, then choose Home > Merge & Center ▼ > Unmerge Cells. Excel keeps the content in the merged area’s upper-left cell; it does not automatically copy that content into the newly separate cells. If you want the value repeated across the former merge, fill those cells after unmerging—and first check whether the merge already discarded other values.
What Happens to Data When Cells Are Merged
A merged range looks like one large cell, but it covers several worksheet cells. For example, merging A1:C1 creates one visible area spanning three columns. Excel stores the range’s content in its upper-left cell, A1. When you unmerge it, A1 retains that content, while B1 and C1 are blank. That is normal behavior, not a failed unmerge.
There is an important distinction between content that is missing because cells were merged and content that you want to add after unmerging. If B1 or C1 contained a value when the cells were merged, Excel warns that only the upper-left value will be kept. Confirming the merge removes the other contents. Unmerging later cannot bring them back. If the cells were blank before the merge, there is nothing to recover; you can choose to copy A1’s value into them as a separate step.
The same principle applies when the upper-left cell contains a formula: the formula remains in that cell after unmerging. Excel does not create a separate copy of the formula in each newly available cell. A merged range can also contain formatting, such as alignment or fill color, so check the appearance of the cells after changing the layout.
Check the Workbook Before You Unmerge
Before changing a workbook you care about, save a copy or use Save As to create a working version. Then inspect the merged areas and decide what the cells should contain afterward. This prevents a common mistake: unmerging first, then assuming that Excel will distribute the heading or label across the old range.
- Identify which cells are merged and note the value or formula displayed in each area.
- Decide whether the content should remain only in the upper-left cell, be repeated across the range, or be placed in a different layout.
- If other cells may have held values before the merge, look for an earlier workbook copy or a recoverable version before making further edits.
- Consider whether you need to keep formulas live or only preserve the values currently displayed.
If you are uncertain about a recent merge, undo it immediately with Ctrl+Z on Windows or Command+Z on a Mac. Undo can reverse the merge while it remains in the workbook’s undo history, but it is not a dependable recovery plan after many later edits, closing the file, or replacing the workbook. Make a copy before experimenting with a complicated sheet.
Unmerge a Cell or Range in Excel
For a single merged area, select any cell in it. For several merged areas, select the range that contains them. On the Home tab, open the dropdown beside Merge & Center and choose Unmerge Cells. In some window sizes the command may appear under the Merge & Center button’s dropdown rather than as a fully visible button. The selected merged cells become separate cells, and the upper-left cell of each former merged area keeps its content.
- Click a merged cell, or drag to select the worksheet range containing the merged cells you want to change.
- Choose Home > Merge & Center ▼ > Unmerge Cells.
- Check the resulting cells. Confirm that the upper-left cells still contain the expected text, number, or formula.
- If you want to repeat a value, select only the cells belonging to that former merged area and use the appropriate fill command.
Unmerge Cells is not the same as Clear Contents. It changes the cell structure; it is not intended to erase the remaining upper-left value. Avoid pressing Delete or choosing Clear Contents if your goal is only to separate the cells. The Home tab’s Clear menu contains commands that remove contents or formatting, so choose the merge command specifically.
Repeat the Value Across the Former Merged Area
For a simple horizontal merge such as A1:C1, unmerge it, select A1:C1, then choose Home > Fill > Right. Excel copies the leftmost cell’s content across the selected row, so the same text or number appears in A1, B1, and C1. On Windows, Ctrl+R is the Fill Right shortcut. For a vertical merge such as A1:A3, select the unmerged range and choose Home > Fill > Down; Ctrl+D is the Windows shortcut. The menu commands are a clear option if a shortcut behaves differently on your keyboard or platform.
For a rectangular merge such as A1:C2, decide whether every cell really needs the same value. If so, unmerge the range, fill the first row to the right, then select the whole rectangle and fill down. This copies the top row into the rows below. If you only need a heading across the first row, fill right across that row and leave the second row blank. Repeating a value is a choice about the data layout, not a requirement of unmerging.
Work on one former merged area at a time when different headings or labels are involved. Filling down or right across a larger selection can copy one label into cells that belong to other records or sections. For example, after unmerging several separate heading blocks, filling the entire column down could overwrite the intended blanks or repeat one heading through the next block. Select a specific block and inspect the result before moving on.
Handle Formulas, Numbers, and Formatting Carefully
If the upper-left cell contains a formula, Fill Right or Fill Down copies the formula, and relative references may adjust as Excel fills. That may be useful if each cell should calculate separately, but it can produce different results from the original displayed value. If you want the same displayed result repeated rather than a working formula, decide whether to convert the formula to a value before filling. You can also fill the formulas, then copy the result range and use Paste Special > Values to replace formulas with their current results. Keep a backup if you may need the original calculations.
Numbers can have formats that affect how they appear. A date, percentage, or currency value may look different from its underlying stored number, and filling can carry formatting as well as content. After filling, check both the displayed values and the number formats, especially when the target cells had different formatting before the operation. Use Paste Special options when you need to control whether you copy values, formulas, or formats rather than treating them as one thing.
Unmerging can also change how borders and alignment look. A heading that was centered across several columns may return to left alignment in its upper-left cell, depending on its formatting. If the goal is still to present a heading across columns without merging, use the alternative below and review the result in Print Preview if the sheet is intended for printing.
Why You Might Prefer Center Across Selection
Merged cells can make worksheets harder to sort, filter, select, and use as structured data. For a horizontal heading that should appear centered over multiple columns, Excel offers Center Across Selection as an alternative that leaves the cells separate. Select the cells, open Format Cells from Home > Format > Format Cells, choose the Alignment tab, and set Horizontal to Center Across Selection. On Windows, Ctrl+1 opens Format Cells; on Mac, use Command+1 where supported, or open the Format Cells dialog from the Format menu.
Center Across Selection changes alignment rather than combining the cells. The text remains in the leftmost cell, while the neighboring cells remain separate and can still hold their own data. This can make a worksheet easier to maintain than a merged heading. The text does not become a value in every cell, however, and the technique is for horizontal presentation; it is not a way to restore contents that were lost during an earlier merge.
For a data table, the most reliable structure is usually one value per cell and no merged cells in the data area. A title above the table can be formatted separately. This makes sorting and filtering more predictable and helps other tools interpret each row and column. Merging may still be suitable for a report or a visual heading, but it is often inconvenient in a range that people need to analyze.
Can You Recover Values Removed by an Earlier Merge?
Unmerge Cells cannot retrieve values that Excel discarded when a merge was confirmed. If the merge just happened, use Undo before doing other work. If the workbook was saved, check whether you have another copy, a backup, or an earlier version. For a file stored on OneDrive or SharePoint, the workbook’s version history may provide an earlier state; availability depends on where and how the file is stored and on your access to it.
Do not assume that blank cells after unmerging once contained data. They may have been empty before the merge. Conversely, if you remember values that are now missing, do not keep editing the only copy in the hope that unmerging will reveal them. Make a separate copy and investigate recovery options first. Excel has no general unmerge command that reconstructs the original contents of every cell.
Frequently Asked Questions
Does unmerging cells delete the value?
Usually, no: the value or formula in the upper-left cell remains there. The other cells in the former merged area are separate and blank unless you fill them. Contents discarded when the cells were originally merged are not restored.
How do I unmerge cells and keep the same text in every cell?
Unmerge the range, select the cells from that one former merged area, and use Home > Fill > Right for a horizontal range or Home > Fill > Down for a vertical range. Check formula behavior before filling if the source is a formula.
Can I unmerge cells without losing the values that were there before?
Only if those values still exist in the workbook or can be recovered from an earlier version. When a merge is confirmed, Excel keeps the upper-left content and removes other contents in the selected range. Unmerging afterward cannot recover the removed values.
Why are the cells blank after I unmerge them?
Only the upper-left cell of each merged area retains its content. The rest become blank, which is expected. If the upper-left cell is blank too, the merged area may have been empty, or its content may have been cleared earlier.
Can I unmerge several cells at once?
Yes. Select a range containing the merged areas and choose Home > Merge & Center > Unmerge Cells. Review each area afterward; Excel retains each area’s upper-left content, but it does not automatically distribute different labels across the newly separated cells.
Related
- Excel Strikethrough Shortcut: Fast Ways to Cross Out Text
- Compare Two Excel Spreadsheets Quickly: Best Methods
- Shade Every Other Row in Excel: Quick, Reliable Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Unable to Share Calendar in Outlook? Fixes That WorkIf you’re unable to share a calendar in Outlook, first check that it belongs to an Exchange or…
- Excel Find Hidden Names: Locate, Review, and Manage ThemTo find hidden defined names in Excel for Microsoft 365 on Windows, run a short VBA macro that…
- Multi-Level Dropdown List in Excel: How to Create OneTo create a multi-level dropdown list in Excel for Microsoft 365 on Windows, put each level’s choices in…
- Excel Shortcut Keys: Essential Shortcuts for Everyday WorkIf you mean important Excel shortcut keys, start with Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo,…
- Create a Table in Excel: Steps, Formatting, and FixesTo create a table in Excel, select a cell in your data, press Ctrl+T on Windows, confirm the…
- Data Validation in Excel: Rules, Lists, and Setup TipsData validation in Microsoft Excel controls what users can enter in selected cells. In Excel for Microsoft 365…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.