Merged cells look clean for headers and section bands. They get in the way when you want to sort, filter, paste, or write formulas across the range.
Unmerging splits the group back into individual cells. Each cell becomes addressable on its own again, which is what most spreadsheet operations need.
There is no built-in keyboard shortcut for unmerging cells in Google Sheets on Windows or Mac. The fastest route is the Merge cells button on the toolbar, or Format > Merge cells > Unmerge.
Is There a Keyboard Shortcut for Unmerging Cells in Google Sheets?
Unmerge Cells Keyboard Shortcut (
Windows)
No native keyboard shortcut on Windows. Use the toolbar Merge button below.
Unmerge Cells Keyboard Shortcut (
Mac)
No native keyboard shortcut on Mac. Use the toolbar Merge button below.
No key combo exists on either platform for this. The fastest way is the Merge cells button on the toolbar. It works as a toggle: click it on a merged cell and it splits the range apart. That method is walked through below.
The value that was in the merged cell lands in the top-left cell after the split. Every other cell in the range comes back empty. That’s worth knowing before you unmerge, especially if the original cells held different values before the merge.
How to Unmerge Cells in Google Sheets (Step by Step)
- Click any cell inside the merged range. Or click and drag to select the whole merged range.
- Find the Merge cells button in the toolbar. It looks like a small box with arrows pointing inward from both sides.
- Click it. The merge releases. The cells split back into the original grid.
- Check the result. The value sits in the top-left cell of what used to be the merged range. The rest are empty.
- If you originally merged with Merge horizontally or Merge vertically (the drop-down options on that same toolbar button), clicking the button still releases the merge the same way.
A quick example. You have A1:D1 merged with the label “Q1 Summary.” Click anywhere in that row, then click the Merge cells button. The merge releases. “Q1 Summary” sits in A1. B1, C1, and D1 are empty.
If A1:D1 held “Q1,” “Summary,” “Total,” and “Notes” before the original merge, those values do not come back. Only the value that was showing in the merged cell is preserved, and it goes to the top-left.
Another Way to Unmerge Cells
The Format menu does the same thing if you prefer menus.
- Select the merged cell or range.
- Click Format → Merge cells → Unmerge.
You can also right-click the merged cell and choose Unmerge cells from the context menu in newer versions of Sheets.
Things to Watch For
- The other cells don’t get their original values back. Whatever was in B1, C1, D1 before the merge is wiped. Sheets keeps only the value of the merged cell, which lives in the top-left. Always copy data out before merging if you might want to unmerge later.
- Sort and filter prefer unmerged data. If you’re getting “this action can’t be performed on a range with merged cells” errors, unmerge first.
- Centering doesn’t survive unmerge. A merged header is usually centre-aligned across the range. After unmerge, the value sits in the top-left cell with whatever alignment that cell had.
- Conditional formatting refers to the top-left cell. If you had a rule applied to the merged range, after unmerge it now points at A1 (or whichever the top-left was). Other cells in the original range lose the formatting.
- No partial unmerge. You can’t keep part of a merge and split the rest. The toggle releases the whole group at once. Re-merge the smaller range afterwards if you need to.
Google Sheets keyboard shortcuts
Related Google Sheets shortcuts: