Unmerge Cells in Google Sheets: Shortcut and Steps

Google Sheets has no dedicated one-keystroke shortcut for unmerging cells. In a browser, open the Tool finder with Alt+/ on Windows or ChromeOS, or Option+/ on Mac, search for Unmerge cells, and choose that command; you can also use Format > Merge cells > Unmerge.

Is there a dedicated unmerge shortcut?

Not in the sense of a specific key combination that immediately splits a selected merged range. Google Sheets provides the Unmerge command in its menus, and the Tool finder offers a quick keyboard-driven way to locate and run it. This distinction matters because shortcut lists and forum answers sometimes describe the Tool finder sequence as though it were a direct shortcut. You still need to open the search, find the command, and activate it.

The Tool finder is useful when you cannot remember where a command lives or would rather not navigate menus. It searches for Sheets commands and can surface the relevant action from a short phrase such as Unmerge cells. It does not change the underlying operation: the selected merged cells are still unmerged using the same Sheets command.

Keyboard layouts and browser settings can affect how a slash or modifier key is entered. If the shortcut does not open the Tool finder, use the menu route instead. You can also check the keyboard-shortcut list in Sheets by opening Help > Keyboard shortcuts; available combinations can vary by operating system and settings.

Use the Tool finder with your keyboard

Select a cell inside the merged range, or select a range that includes the merged cells you want to split.
Press Alt+/ on Windows or ChromeOS. On Mac, press Option+/.
Type Unmerge cells in the Tool finder.
Choose the matching command. If the result is highlighted, press Enter; otherwise use the arrow keys to move to it and press Enter.

After the command runs, the merged area becomes separate cells again. If the search does not show the command, first confirm that your selection contains a merged cell. Searching for just unmerge may also help if the full phrase does not bring up the result immediately.

This is a convenient method for occasional use, but it is not always the fastest option if the Format menu is already open or you are using a touch device. In those cases, selecting the command from the menu or toolbar may take fewer actions.

Use the Format menu or toolbar

The menu route is consistent and easy to verify: select the merged cell, then choose Format > Merge cells > Unmerge. If the selected cells are not merged, the Unmerge option may be unavailable. The menu is a good choice when you want to see the command’s location or when the Tool finder shortcut is unfamiliar.

Sheets also has a merge control in the toolbar. Select the merged cell, open the merge control’s dropdown, and choose Unmerge if that option is shown. The exact appearance can depend on the available toolbar space and window size, so the Format menu remains a dependable fallback. Avoid clicking the main merge button without checking its current action: that button may merge cells rather than split them.

On a phone or tablet, the desktop keyboard shortcut may not apply. Use the Sheets app’s formatting controls and look for the cell-merging options; the arrangement can differ from the browser version. If you are following instructions for a browser, make sure you are actually using Google Sheets on the web rather than the mobile app.

Select the right cells before unmerging

For one merged block, clicking any cell within that block is usually enough to make the Unmerge command available. You do not have to select each constituent cell separately. If you are working with several merged blocks, select a range covering the blocks you intend to split and check the result afterward, especially if the selection also includes ordinary cells.

For example, suppose a heading is merged across B2:D2 and another heading is merged across B5:D5. Selecting a range that covers both headings and using Unmerge can split the merged blocks in that selection. The cells between or around them are not converted into merged cells; they simply remain as they were. For a large or irregular sheet, it can be safer to handle one area at a time so you can confirm which headings changed.

When the selection is difficult to make, click the merged area and look at the cell reference box beside the formula bar. It can help identify the range associated with the selection. You can also zoom in or widen columns temporarily if merged headings are hard to distinguish. Before applying the command across a broad range, confirm that it does not include merged cells elsewhere in the sheet that you meant to preserve.

What happens to the contents?

Unmerging separates the cells; it does not reconstruct values that were removed when the cells were originally merged. When cells are merged, Sheets keeps the contents of the upper-left cell of the merged range. Content in other cells can be discarded during the merge. After unmerging, the upper-left cell retains its value, while the other cells in the former merged area are generally blank.

For example, if B2:D2 was merged with the text Quarterly results in B2, unmerging returns B2, C2, and D2 as separate cells, with the heading in B2. It does not automatically copy that heading into C2 and D2. If another value was present in C2 before the merge, unmerging will not bring it back. If you need to recover prior contents, use Undo immediately after the merge if it is still available, or restore an earlier version from the file’s version history.

Unmerging is different from filling or copying. It does not distribute a value across the newly separate cells, and it does not move the surviving value to the center of the former range. If you want a heading to appear centered across several columns without combining cells, consider using horizontal alignment options such as Format > Alignment instead. That keeps the cells separate while changing how the text is displayed.

Why unmerge cells?

Merged cells can make a report look orderly, particularly for a title spanning multiple columns. They can also complicate ordinary spreadsheet work. A merged heading may make it harder to select a consistent block, sort records, use filters, or copy and paste data into another application. Tables intended for analysis generally work better when each record has its own row and each field has its own column, without merged cells inside the data area.

Unmerge when you need to restore a regular grid or make a layout easier to edit. Common examples include:

Preparing a sheet for sorting or filtering because a merged cell crosses the rows or columns being handled.
Copying a rectangular data range into another sheet or a data-processing tool.
Adding separate labels or formulas to cells that were previously part of one merged block.
Fixing a selection that behaves unexpectedly because a cell spans multiple rows or columns.

For presentation sheets, merging can still be a deliberate layout choice. The practical question is whether the range is primarily a visual heading or part of a structured data table. Keeping titles outside the data table, or using alignment without merging, can reduce problems later.

Common problems and fixes

Unmerge is greyed out. The active selection may not contain a merged cell. Click directly inside the merged block and check the Format menu again. If you are in a protected sheet or range, your permission level may also limit changes; ask the file owner for editing access or an adjustment to the protection.

The keyboard shortcut does nothing. Confirm that you are using the browser version and the correct operating-system combination: Alt+/ on Windows or ChromeOS, and Option+/ on Mac. Keyboard layouts, browser behavior, or a different app can affect the key sequence. The dependable alternative is to use Format > Merge cells > Unmerge.

Only some cells appear to change. Check the boundaries of the selected range and inspect each merged block. A selection that does not include a particular merged area will not unmerge it. If you are unsure, undo the operation right away with Ctrl+Z on Windows or Command+Z on Mac, then select the intended range more carefully.

Text seems to have disappeared. Unmerge does not restore values lost when the cells were merged. Check the formula bar for the surviving value, and use Undo or version history if you need an earlier state. Avoid making additional edits before deciding whether you need to undo, because undoing later actions can also remove those edits.

Unmerge versus other layout options

Unmerge is the right choice when you want the cells to become independent again. If you only want the text to look centered across a heading, horizontal alignment can often achieve a similar appearance without combining the cells. In Sheets, select the cells and use the horizontal alignment control in the toolbar, or open Format > Alignment. The available alignment choices apply to the selection; they do not merge the cells.

Another alternative is to keep a title in a single cell and leave neighboring cells empty. That approach can be more robust for a sheet that will later be filtered, sorted, or copied. If several columns need a shared label, consider placing the label in its own row above the data and keeping the columns below it unmerged.

Excel uses a different menu structure, so Google Sheets instructions should not be assumed to match it. In Excel for Microsoft 365 on Windows, the corresponding command is on Home > Merge & Center dropdown > Unmerge Cells. In Google Sheets, use the Format menu path or Tool finder described above.

Frequently Asked Questions

What is the shortcut to unmerge cells in Google Sheets?

There is no dedicated direct shortcut for the Unmerge command. Use Alt+/ on Windows or ChromeOS, or Option+/ on Mac, to open the Tool finder, search for Unmerge cells, and choose the command.

Can I unmerge several ranges at once?

You can select a range containing multiple merged blocks and run Unmerge, then inspect the affected area. For nonadjacent or complex selections, work in smaller sections to avoid changing merges you wanted to keep.

Will unmerging restore the values from every cell?

No. Unmerging separates the cells but does not recover values discarded when the cells were merged. The upper-left cell’s content is retained; use Undo or version history if you need to recover an earlier version.

Why can’t I click Unmerge?

The selection may not contain a merged cell, or you may lack permission to edit a protected range. Select a cell inside the merged block and check again; if protection is the issue, ask the sheet owner to change your access.

Does unmerging delete the text?

It normally leaves the surviving value in the upper-left cell of the former merged range. It does not spread the text across the other cells, which are typically blank after unmerging.

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.