Excel Unmerge Cells: What Happens to the Text?

How-to basics · Updated November 18, 2026

To unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell, then choose Home > Merge & Center ▼ > Unmerge Cells. Excel keeps the value in the merged area’s upper-left cell; it does not restore text or values that were in the other cells before they were merged.

What “unmerge” does to cell text

Merging combines a selected rectangular range into one larger cell. For example, merging A1:C1 creates one cell that occupies the space of three columns. The value Excel retains is the one from A1, the upper-left cell. If B1 and C1 contained separate text before the merge, Excel removes those values during the merge and does not bring them back when you unmerge.

After you unmerge A1:C1, A1:C1 are separate cells again. The retained value remains in A1, while B1 and C1 are blank. Unmerging changes the cell structure; it is not an undo or recovery feature. If you need the original contents of cells that were overwritten by a merge, you will need to recover them from a prior version, backup, or other source.

This distinction matters when a heading looks like it spans several columns. The text may be stored in only one cell, even though it visually stretches across the merged area. Unmerging makes that storage arrangement visible again.

Unmerge cells in Excel for Microsoft 365

  1. Click the merged cell. To unmerge more than one area, select the relevant range or ranges, if Excel allows you to make that selection.
  2. Open the Home tab.
  3. In the Alignment group, open the drop-down beside Merge & Center.
  4. Choose Unmerge Cells.

The command is also available from the Merge & Center button when a merged cell is selected. If the button is not obvious, widen the Excel window or look in the Alignment group; the ribbon may show a compact control when the window is narrow. There is no standard direct keyboard shortcut for unmerging. On Windows, you can use the ribbon key sequence Alt, H, M, U to reach the command, pressing the keys in order rather than simultaneously. Key tips can vary with ribbon configuration.

In Excel for Mac, select the merged cell and use Home > Merge & Center > Unmerge Cells. Excel for the web also provides the unmerge command on the Home tab, though the ribbon may display controls differently depending on window size. If you cannot find it, expand the Merge & Center menu.

What happens when you unmerge a larger range

Suppose a report title is merged across B2:E2. After unmerging, the title remains in B2, and C2:E2 become separate cells. If the title was centered in the merged area, it may no longer appear centered across the four columns. That is a change in appearance, not a loss of the title: the text is still in B2, and you can adjust alignment or use a different layout method.

Unmerging does not automatically recreate the original arrangement of values. Nor does it know whether a merged area was intended as a heading, a form field, or a visually grouped block. Check the cells and their formatting after the command, especially before printing or sharing the workbook. Borders, alignment, and fill may need attention to make the unmerged layout look the way you want.

If a worksheet contains several merged areas, inspect the whole selection before changing it. A broad selection can include merged cells that serve different purposes, and unmerging them all may alter the layout in places you did not intend. For a complex sheet, work on a copy or select and unmerge one region at a time.

How to preserve or recover text before unmerging

If the merged cells still exist and you are unsure what they contain, make a copy of the workbook before changing them. That protects the current file, but it cannot reveal values already discarded by an earlier merge. To recover those, check whether the workbook is still open and whether the merge was the most recent action: Ctrl+Z on Windows or Command+Z on Mac may undo it. Undo can also reverse later actions, so review the result before saving.

If the file has already been saved, possible recovery sources include:

  • Version history: For a workbook stored in OneDrive or SharePoint, use its version history to inspect or restore an earlier version. The exact controls depend on where you open the file.
  • A backup or separate copy: Look for an earlier workbook, emailed attachment, or exported copy containing the original data.
  • Another source of the information: If the values came from a report, database, or form, retrieve them there rather than assuming Excel can reconstruct them.

Before restoring an older version, consider saving the current workbook under a different name. Restoring can replace newer changes along with the merged cells, so compare versions and copy back only what you need when possible. If the other cells were blank before the merge, there is no missing text to recover; unmerging simply makes those blank cells visible again.

Fill the unmerged cells with repeated text

Sometimes the goal is not to recover distinct original values but to put the same label in every cell that used to be merged. For example, after unmerging A1:C1, you may want the word “North” in A1, B1, and C1. Unmerge the range first, then select A1:C1, type North, and press Ctrl+Enter on Windows to enter the same value into every selected cell. On Mac, use Control+Return in many Excel configurations; keyboard behavior can depend on the version and settings, so check the result before continuing.

This fills every selected cell with the same text. It does not restore separate labels, and it will overwrite existing values in the selection. If you want to fill only blank cells, first confirm the range contains no information you need to keep. Another straightforward option is to enter the value in the first cell and use Excel’s fill handle to copy it across, checking the result afterward.

For a table where each row needs a heading repeated, filling values can make filtering and sorting more practical than merged cells. However, avoid copying a label into cells where it would falsely imply that each row has a separate category. Choose the data structure that matches what the rows actually mean.

Unmerging is different from splitting text

“Unmerge text” can also mean separating words or pieces of data that are together in one cell. That is a different operation. If A2 contains Lee, Morgan and you want the name in separate columns, unmerging cells will not split the text. Use Data > Text to Columns in desktop Excel instead: select the cells, choose Delimited if a comma, space, or other separator divides the parts, specify the delimiter, and check the preview before completing the wizard.

Text to Columns writes its results into neighboring cells. Make sure those destination cells are empty or the existing contents could be overwritten. For a comma-separated name, select comma as the delimiter; if there is a space after the comma, use the option to treat consecutive delimiters as one only when that suits the data. Names and addresses can have exceptions, so inspect the preview and results rather than assuming one delimiter will split every entry correctly.

Use Unmerge Cells when one cell spans multiple rows or columns and you want separate cells again. Use Text to Columns when one cell contains multiple text parts that should be placed in separate columns. If you only want a heading visually centered across several columns, consider a formatting alternative instead of merging.

Alternatives to merging cells

Merged cells can make headings look tidy, but they can complicate sorting, filtering, copying, and selecting ranges. In a data table, a merged cell may also leave only one row with a category value while the other rows appear blank. That makes the sheet harder to use as a consistent list. For a title above a table, keep the title outside the data area where possible.

In desktop Excel, Center Across Selection can center a heading over multiple columns without merging them. Select the cells, open Format Cells (for example, press Ctrl+1 on Windows), go to the Alignment tab, and choose Center Across Selection in the horizontal alignment list. The cells remain separate, so this approach avoids the single-cell structure created by a merge. Availability and presentation can differ in Excel for the web; if the option is not available there, use desktop Excel to apply it.

Another option is to leave the text in one cell and adjust column widths, wrapping, or alignment. For data-entry templates, repeating a label in each relevant row is often clearer than merging cells. The best choice depends on whether the range is a decorative heading or actual data people need to sort, filter, or analyze.

Common problems after unmerging

  • Unmerge Cells is unavailable: Check that the selection includes a merged cell and that the worksheet is not protected in a way that prevents the change. If the sheet is protected, you may need permission or the password to unprotect it.
  • The text appears to disappear: Look in the upper-left cell of the former merged area. Excel keeps the value there, even if the new column width or alignment makes it less visible.
  • The text is not centered anymore: Unmerging removes the spanning cell arrangement. Apply alignment again or use Center Across Selection in desktop Excel if appropriate.
  • Only one cell has a value: This is expected. Unmerge does not copy the retained value to the other cells; fill them only if repeated values are what you intend.
  • The worksheet layout shifts: Check column widths, row heights, borders, and wrapped text. A formerly merged heading may need a new layout to fit.

Also distinguish unmerging from undoing. If you have just merged cells and want to reverse that action while restoring the previous contents, use Undo immediately if possible. Choosing Unmerge Cells after the merge will separate the range but cannot recover values removed when the merge occurred.

Frequently Asked Questions

Does Excel restore text when I unmerge cells?
No. Excel keeps the value from the upper-left cell of the merged range. Values that were in the other cells before merging are not restored by unmerging.

Where does the text go after I unmerge a cell?
It stays in the upper-left cell of the former merged area. The other cells become separate cells and are usually blank unless they already contain content.

Can I unmerge cells without losing the visible text?
Yes, the retained text stays in the upper-left cell. But if you mean restoring several different values that were present before the merge, unmerging alone cannot do that; use Undo, version history, a backup, or another source.

How do I put the same text in every cell after unmerging?
Select the unmerged cells, type the text, and use Ctrl+Enter on Windows to enter it throughout the selection. This replaces existing values in the selected cells, so check the range first.

How do I split words in one Excel cell?
Use Data > Text to Columns and choose a delimiter such as a comma or space. Unmerge Cells changes a merged layout; it does not divide text inside a cell.

Can I unmerge several cells at once?
Yes, you can select a range containing merged cells and use Home > Merge & Center > Unmerge Cells. Review the selection first, because every merged area included in it may be unmerged.

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.