How to Split Merged Cells in Google Sheets Safely

To split merged cells in Google Sheets, select a merged cell, then choose Format > Merge cells > Unmerge. The cell becomes separate cells again; any content that remains is in the upper-left cell, while the other cells are usually blank. Before you begin, note that unmerging does not recover values discarded when the cells were originally merged.

What You’ll Need

A Google account with access to the spreadsheet, plus a web browser and an internet connection.
Editing permission for the sheet. If you can only view it, ask the owner for access or make a copy if the sharing settings allow it.
A moment to check what is in the merged cell and its surrounding rows or columns, especially if the sheet contains important labels or data.

You do not need an add-on, formula, or special setting. The instructions below are for Google Sheets in a desktop web browser. You can also use Sheets on a phone or tablet, but the controls are arranged differently; the browser steps are generally easier when you need to inspect a large range.

Step-by-Step

Open the spreadsheet and identify the merged area. Go to Google Sheets and open the file. Look for a cell that appears to span multiple rows, multiple columns, or both. For example, a heading that stretches across columns A to C may be one merged cell rather than three separate cells. Click the area once to select it. The blue selection outline should show the full merged area.
Check what the cell contains before changing it. Read the text in the formula bar above the grid, or look at the cell itself. If the value matters, copy it somewhere safe first, such as a temporary cell outside the data range or a note. Merging commonly leaves only one value, usually the value from the upper-left cell; other values may already have been removed during the merge. Unmerging cannot bring those discarded values back.
Open the Merge cells menu. In the menu bar at the top of the sheet, click Format, then point to or open Merge cells. The submenu includes merge options and the command to undo a merge. If the menu is hard to use, make sure the sheet is in editing mode and that you have selected a cell within the merged area.
Choose Unmerge. Click Unmerge in the submenu. Google Sheets separates the merged area into its original grid of individual cells. For a cell merged across three columns, for instance, the three columns become separate cells again. The value that was in the merged cell stays in the upper-left cell of that area; the other cells generally have no value.
Verify the result and the data around it. Click each newly separated cell, or use the formula bar to check its contents. Confirm that the original heading or label is where you expect it and that neighboring data has not been shifted or overwritten. If the purpose was to make the sheet sortable or usable as a data table, check that each row now has the expected number of separate cells.
Repeat for other merged areas. Click another merged area and use Format > Merge cells > Unmerge again. For several merged areas, you can select a range containing them and use Unmerge, but check the selection first: the command acts on merged cells within the selected range, and selecting only part of a merged area can make the result less predictable. For the clearest control, unmerge one area at a time.
Review formatting and save your work. Check borders, alignment, text wrapping, and row or column sizing after unmerging. The cells may not look exactly like a set of cells that were never merged. Google Sheets saves edits automatically, but wait for the save indicator to finish before closing the tab, especially if the connection is slow.

You can also use the merge control on the toolbar if it is visible: open its dropdown and choose the unmerge option. The menu path is a dependable alternative because toolbar layouts can vary with window size. There is no need to delete rows or columns to separate a merged area; doing so would change the sheet structure rather than simply unmerge the cells.

Common Mistakes

Expecting unmerge to restore every original value. Unmerge separates the grid; it does not reverse the history of a merge. If several cells held content before they were merged, some of that content may have been lost when the merge was made. Check version history or undo, if appropriate, rather than expecting Unmerge to restore it.
Selecting the wrong cells. A merged cell can cover several rows or columns, so the visible text may not indicate its full size. Click the merged cell and check the blue outline before choosing the command. If you select a large range accidentally, you could unmerge other areas in that range as well.
Using Merge instead of Unmerge. The submenu has multiple merge choices, including options that merge horizontally or vertically. Read the command before clicking. If you merge cells again by mistake, use Edit > Undo immediately, if the action is still the most recent change.
Confusing a wide cell with a merged cell. A cell may look wide because the adjacent columns are empty or because the column width is large. Click it and inspect the selection outline. If the outline does not span multiple cells, it is not a merged range, and Unmerge may be unavailable.
Unmerging a heading without considering the layout. A centered title across a table can become left-aligned in the upper-left cell after separation, while the remaining cells are blank. The data may be correct even if the page looks different. Decide whether you need a real merged heading or a layout alternative before changing many headings.

Tips

Make a copy before a broad cleanup. Choose File > Make a copy if you are about to unmerge many cells in a shared or important spreadsheet. A copy gives you a separate version to compare if the range or formatting changes unexpectedly.
Unmerge a small test area first. If the sheet has many merge patterns, try one example of each type, such as a horizontal heading and a vertical label. Check how the values and formatting behave before selecting a larger range.
Keep a note of the original layout. A quick screenshot or a note of the merged range addresses can make it easier to recreate a presentation-style heading later. This is especially useful when a sheet is being converted into a clean data table.
Use one value per cell for data work. Sorting, filtering, and importing are usually easier when each record has its own cells and headers are in a single row. If a heading needs to appear centered across several columns, consider selecting those cells and using Format > Alignment to adjust alignment rather than merging them, where that suits the layout.
Distinguish the grid from the text. Unmerge changes the cell structure, not the wording inside the cell. If your goal is to split a phrase into separate cells, use a suitable data-splitting method instead; unmerging will not divide words or values.
Know the Excel equivalent. In Excel for Microsoft 365 on Windows, select the merged cell and choose Home > Merge & Center dropdown > Unmerge Cells. Google Sheets uses Format > Merge cells > Unmerge; the menus and behavior should not be assumed to be identical.

Troubleshooting

Unmerge is disabled or missing. Confirm that the selected cell is actually part of a merged area. If it is, click the cell directly rather than selecting a neighboring cell, then open Format > Merge cells again. If you have view-only access, request editor permission. Also check whether the file is still loading or whether your browser window is displaying a limited menu; widening the window or refreshing after confirming your work is saved can help.

The command affects more cells than expected. Undo the change promptly with Edit > Undo or Ctrl+Z on Windows and ChromeOS; on a Mac, use Command+Z. Then select one merged area and repeat the operation. When a selected range contains multiple merged areas, inspect the whole range before using Unmerge, since you may not intend to separate every merged cell inside it.

The text appears only in one of the new cells. That is normal. The surviving value is typically in the upper-left cell of the merged range, and other cells are blank. If the missing information was there before the merge, try Edit > Undo if the merge was recent. Otherwise, use File > Version history > See version history to inspect an earlier version. Restoring a version changes the spreadsheet to that earlier state, so consider copying needed information from it rather than restoring the whole file.

The cells separate but look uneven. Check alignment, text wrapping, borders, and row height or column width. Unmerging does not automatically make the surrounding layout attractive or normalize dimensions. Select the affected cells and adjust the relevant formatting controls, taking care not to apply a change to unrelated cells.

You cannot find the controls on a phone or tablet. The Sheets mobile app has a different interface, and menu labels or locations can vary by device and app version. Select the merged cell and look in the formatting controls for the cell-merging option, then choose its unmerge command if available. If you cannot locate it, open the file in a desktop browser and follow the menu path above. Avoid changing the file through an unfamiliar control if you are not sure which range it will affect.

Frequently Asked Questions

Does unmerging delete the text?

Usually, the value in the merged cell remains in the upper-left cell after unmerging. The other cells become separate and are generally blank. Unmerge does not split the text into pieces, and it cannot restore content that was discarded when the cells were merged.

Can I unmerge several cells at once?

Yes. Select a range that includes the merged areas, then choose Format > Merge cells > Unmerge. Review the range first so you do not unmerge areas you want to keep merged. For mixed or complicated layouts, work on one merged area at a time.

Why is Unmerge unavailable?

The selected cell may not be merged, you may have clicked beside the merged area, or you may not have editing permission. Click directly inside the apparent merged cell and check its selection outline. If no merged area is selected, the command may not be available.

Will unmerging change the formatting?

It can change how the sheet looks because one area becomes multiple cells. Inspect alignment, borders, wrapping, and row or column sizes afterward. If appearance matters, take a copy or screenshot before making a large set of changes.

Can I split the words in a merged cell into separate cells?

No. Unmerge separates the cell area into its component grid cells; it does not divide the contents. To separate text such as a first and last name, use a text-splitting approach after unmerging, and check the destination cells so existing data is not overwritten.

Can I undo an unmerge?

Use Edit > Undo immediately if unmerging was your latest action. The keyboard shortcut is Ctrl+Z on Windows or ChromeOS and Command+Z on Mac. If you have made many changes since then, check version history or work from a saved copy instead.

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.