How to Remove Merged Cells in Google Sheets

To remove merged cells in Google Sheets, select a merged cell or range, then choose Format > Merge cells > Unmerge. The cells become separate again, but unmerging does not restore any values that were removed when they were first merged. Before you start, note which cells contain important data and make a copy if you are working with a sheet you cannot easily recreate.

What You’ll Need

A Google account with permission to edit the spreadsheet. View-only access will not let you change merged cells.
The spreadsheet open in Google Sheets in a web browser. These instructions use the desktop browser menus; the Google Sheets mobile app has a different layout.
A moment to check what the merged area contains. In a merged range, the upper-left cell is the anchor cell, and that is the cell whose content remains after unmerging.

You do not need an add-on, script, or special setting. If the sheet is important, make a duplicate first with File > Make a copy. That gives you a separate version to return to if you unmerge the wrong area or later discover that you need the original layout.

Step-by-Step

Open the spreadsheet and find the merged area. Look for a cell that appears to span two or more rows or columns. Click it once. A merged cell behaves as one selectable area, even though its outline covers several grid cells. If you are unsure where the merge begins and ends, check the column letters and row numbers along its edges.
Check the contents before changing anything. Click the merged cell and look at the formula bar above the grid. This can help you see the full value if it is too long to display in the cell. Remember that unmerging separates the grid cells, but it does not recreate separate values for each one. If you need to preserve the displayed text, make a note or copy it before proceeding.
Open the Merge cells menu. In the top menu, click Format, point to Merge cells, and choose Unmerge. The exact path is Format > Merge cells > Unmerge. Do not choose one of the merge options, such as Merge all, because those options combine cells rather than separate them.
Confirm that the cells are separate. The former merged area should now show its ordinary row and column boundaries. Click one of the cells that used to be inside the merge. The selection border should cover just that individual cell, rather than the entire former merged area. The existing value normally stays in the upper-left cell of the range.
Repeat for other merged areas. Select another merged cell and use the same menu path. If a sheet has several scattered merges, work through them one at a time so you can check the result and avoid changing unrelated formatting or layout.
Unmerge every merged cell in the sheet, if that is your goal. Click the blank square at the top-left corner of the grid, where the row numbers and column letters meet, to select the sheet grid. Then choose Format > Merge cells > Unmerge. Check the sheet afterward, especially if it contains many sections with different layouts. Selecting the grid and unmerging affects merged areas throughout the selected sheet, not just the currently visible rows.
Review the layout and save your work. Unmerging can leave text in a narrow cell, so it may look cut off even though the value is still there. Widen columns, adjust row heights, wrap text, or realign headings as needed. Google Sheets saves changes automatically, but wait for the saved indicator near the top before closing the tab.

If you accidentally unmerge the wrong cells, use Edit > Undo right away, or press Ctrl+Z on Windows or ChromeOS. On a Mac, use Command+Z. Undo is most reliable immediately after the action; if you have made many later edits, undoing may also reverse those edits. For an older version, use File > Version history > See version history to inspect or restore a previous version. Restoring an older version can also roll back other changes, so check the version carefully.

Common Mistakes

Expecting values to return to every cell. Unmerge only restores the separate cell boundaries. It does not put old text or numbers back into the other cells. When cells were originally merged, content outside the upper-left cell may have been removed. If that information matters, try Undo immediately or look for it in version history.
Selecting the wrong command. The Merge cells submenu contains actions that combine cells as well as the Unmerge command. Read the menu item before clicking. If the selected range contains no merged cells, Unmerge may be unavailable or have no visible effect.
Assuming only the visible part is selected. Clicking anywhere inside a merged area selects that merged cell as one unit. Unmerge applies to the full merged area, not just the particular row or column portion where you clicked.
Unmerging the whole sheet by mistake. Selecting the grid and choosing Unmerge can affect many sections at once. If you only meant to fix one heading, click that heading first instead of using the select-all square. Use Undo promptly if you applied the whole-sheet action unintentionally.
Thinking clipped text has disappeared. After unmerging, the text may remain in the upper-left cell but no longer fit in its narrower width. Check the formula bar before assuming the value is gone, then resize the column or turn on text wrapping.
Confusing merge with alignment or borders. Centered text, hidden gridlines, matching background colors, or cell borders can make separate cells look like one. Select the suspected area and check whether the Merge cells menu offers Unmerge. If it does not, the cells may not actually be merged.

Tips

Make a copy before bulk changes. Choose File > Make a copy before unmerging a whole worksheet or a complicated report. A copy is a safer fallback than relying on Undo after additional edits.
Use unmerged cells for data tables. Merged cells can interfere with sorting, filtering, and selecting consistent ranges. For a table that needs a centered heading, keep the data cells unmerged and format the heading separately. If you need a visual heading across columns, consider centering the text in the heading cell or adjusting its alignment rather than merging cells in the data area.
Check formulas and references afterward. A formula that refers to the upper-left cell will generally still refer to that cell after unmerging. But a layout change may make a formula, chart, or instruction less clear. Review nearby calculations and labels if other people use the sheet.
Fix the display after unmerging. A heading that used to span several columns may now appear crowded in its first cell. You can widen that column, wrap the text using the text-wrapping control on the toolbar, adjust alignment, or put the heading in a suitable cell without merging the data beneath it.
Work in small groups when the layout is complex. If a sheet has different kinds of merges, unmerge one section at a time and check each result. This helps you spot where headings, labels, or print layouts need extra formatting before moving to the next section.
Remember that Excel uses a different menu path. These steps are for Google Sheets in a browser. In Excel for Microsoft 365 on Windows, the related command is on Home > Merge & Center (open its dropdown) > Unmerge Cells. Do not follow that ribbon path in Google Sheets.

Troubleshooting

Unmerge is missing or disabled. First click a cell that appears merged, then open Format > Merge cells again. If Unmerge is still unavailable, the cell may not be merged, you may have selected a different range, or you may not have editing permission. Check whether the file is in view-only mode and ask the owner for edit access if necessary.

The command runs, but nothing seems to change. Look closely at the row and column boundaries. If the area was already unmerged, the command has no visible work to do. If it was merged, the grid boundaries should reappear. A cell’s background color or borders can still make separate cells look connected, so inspect the selection and the Merge cells menu rather than relying only on appearance.

The value looks like it vanished. Click the upper-left cell of the former merged range and inspect the formula bar. The value from a merged range is associated with that anchor cell; other cells in the range do not receive copies when you unmerge. If the needed content was removed during the original merge, try Edit > Undo if that merge was recent. Otherwise, open version history and look for a version from before the merge. A previous version may contain other changes too, so consider making a copy before restoring it.

The text is present but cut off. Unmerging can make the anchor cell narrower than the former merged area. Select the column letter and drag its right boundary to widen it, or use text wrapping from the toolbar. You can also increase the row height or change alignment. These display adjustments do not change the cell value.

You cannot edit the sheet. If the menu commands are unavailable across the spreadsheet, check the sharing status at the top of the page. A viewer or commenter cannot unmerge cells. Request editor access from the file owner. If you are already an editor but a protected range blocks the change, ask the owner or administrator to update the protection settings.

A whole-sheet unmerge changed more than expected. Use Undo immediately if possible. If later edits mean Undo is no longer appropriate, inspect version history and decide whether restoring a prior version is worth losing any changes made since then. You can also make a copy of the current file first, so you can compare the current and earlier layouts without losing the present state.

Frequently Asked Questions

Can I unmerge cells without deleting the value?
The value in the upper-left cell remains when you unmerge. The other cells become empty; unmerging does not duplicate the value across them. Copy the value elsewhere first if you need to reuse it.

Can I unmerge just part of a merged cell?
No. A merged range is treated as one cell, so unmerging separates the full merged range. You cannot unmerge only one row or column from within that same merge. Afterward, you can select and merge a different, smaller range if that better suits the layout.

How do I remove every merge in a worksheet?
Click the blank square above row 1 and to the left of column A to select the grid, then choose Format > Merge cells > Unmerge. Review the sheet afterward because the action affects all merged ranges in the selected grid and can change how headings fit.

Will unmerging change formulas?
Unmerging does not itself rewrite formulas. A formula that refers to the upper-left cell will continue to refer to that cell, but check nearby formulas and reports if their layout or references depend on the merged area.

Can I recover text that was lost when cells were merged?
Unmerge cannot recover content that was cleared when the merge was created. If the merge just happened, use Undo. For an older change, check File > Version history > See version history for a version that still contains the original data.

Why do separate cells still look merged?
Matching fill colors, borders, hidden gridlines, or centered text can create that appearance. Select the area and check Format > Merge cells. If Unmerge is not available, adjust the formatting or borders instead; the cells may already be separate.

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.