How do you unmerge cells in Google Sheets?
Unmerge splits a merged block back into individual cells. Only the top-left cell keeps the displayed value; other cells become empty. Unmerge is the first fix when sort fails, filters break, or you need to paste data into what was one big title cell covering your table.
When to use it
Unmerge when inheriting templates with merged data rows, before converting a pretty report layout into a workable table, or when charts need a clean rectangular source range.
When to skip it
If the merge is intentional for a title-only row and data lives below in unmerged rows, leave title merge alone and fix only data section merges.
How it works
-
1
Click inside merged area, Format > Merge cells > Unmerge.
-
2
Recover lost cell values from version history if unmerge destroyed data you still need.
-
3
Re-enter or paste values into individual cells after unmerge before sorting.
-
4
Clear stray formatting if unmerge leaves uneven borders from old layout.
-
5
Reapply validation per cell after unmerge on former input blocks.
-
6
Document layout change for team so nobody re-merges out of habit.
Examples in Google Sheets
Fix sort on roster
Unmerge name columns, paste names from backup column, sort alphabetically for mail merge.
Chart source cleanup
Unmerge header block mistakenly including first data row so chart range is continuous.
Import prep
Unmerge all cells on tab copied from PDF table paste before running cleanup scripts.
Better Sheets resources
Common mistakes
-
Unmerge without checking version history when only one value survived from many cells.
-
Assuming unmerge restores all previous values automatically (it does not).
-
Unmerge then sort while related columns still misaligned from old layout.
-
Leaving partial merges in middle of table still blocking filter.
-
Re-merging data rows after fix because title row looked lonely.
Frequently asked questions
- Where is unmerge?
- Format > Merge cells > Unmerge when selection is merged.
- Recover data after unmerge?
- File > Version history if you need pre-unmerge state.
- Unmerge all in sheet?
- Select used range or whole sheet carefully and unmerge; watch performance on huge tabs.
- Unmerge and formulas?
- Formulas referencing top-left may need range expansion after unmerge.
- Unmerge checkbox column?
- One checkbox per cell after unmerge; re-insert controls if lost.
- Unmerge for FILTER?
- FILTER needs consistent row heights without merged blocks in source.
- Unmerge CSV export?
- Unmerged grids export cleaner columns to CSV for downstream tools.
- Prevent merge accidents?
- Protect structure ranges and train team to merge only title rows.
Related Tutorials
Watch how Unmerge cells works
How to Merge Cells in Google Sheets
Combine Sheets Into One Sheet As It Happens
Related blog posts
Guides that explain Unmerge cells in more depth.
5 More Fixes For Your Spreadsheets
Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...
Read post →5 Ways to Combine Names in Google Sheets
Ever found yourself stuck in a loop of copying and pasting names in Google Sheets? Let's face it, it's a task that can feel like a never-ending chore. But fear not, because I've got your back! So, we're diving into the world of Google Sheets and exploring five super-easy ways to combine first and last names into a single cell. No more manual labor, no more headaches. Imagine being able to whip up a list of full names in seconds, instead of spending hours on it. Sounds like a dream, right? We...
Read post →Related terms
Merge cells
Merge cells combines a rectangular selection into one display cell. Only the top-left cell value survives; others are discarded. Merged blocks suit dashboard titles and form-like layouts but break many data operations. Use merge sparingly on tables that sort, filter, or feed formulas.
Read guide →Wrap text
Wrap text displays cell content on multiple lines within the same cell instead of spilling into neighbors. Format > Text wrapping > Wrap increases row height automatically so paragraphs, addresses, and long headers remain readable without widening columns across the whole sheet.
Read guide →Cell overflow
Cell overflow is the default behavior where long text visually extends into empty neighboring cells to the right without changing their values. The next non-empty cell clips the spill visually. Overflow keeps row height compact but can make dense tables look messy or hide which cell actually holds the data.
Read guide →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, percent, date, and plain text formats keep reports readable and prevent Sheets from auto-converting IDs into dates. Good formatting is the difference between a sheet leadership trusts and one they argue with.
Read guide →Done reading about Unmerge cells?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.