How to Merge Cells in Google Sheets
Google Sheets offers three merge types — Merge all, Merge horizontally, and Merge vertically. All are accessed from Format → Merge cells or the merge icon in the toolbar. Merging cells with data keeps only the top-left value.
⚡ Quick Answer
Select adjacent cells, click Format → Merge cells → Merge all. If cells contain data, only the top-left value is kept. To unmerge, click the merged cell and click merge again — it toggles.
The three merge types
| Option | What it does | Best for |
|---|---|---|
| Merge all | Combines entire selection into one cell | Section headers spanning columns |
| Merge horizontally | Merges each row separately (columns collapse) | Merging multiple rows at once |
| Merge vertically | Merges each column separately (rows collapse) | Vertical labels spanning rows |
| Unmerge | Splits a merged cell back into individuals | Undoing a merge |
Method 1: Format menu (most common)
Select adjacent cells
Highlight cells to merge. They must be next to each other.
Click Format → Merge cells
A submenu shows the three merge options plus Unmerge.
Choose your merge type
Click Merge all for the simple case. Sheets combines the cells; only the top-left value survives.
Method 2: Toolbar button
Select cells
Highlight the range.
Click the merge icon
In the toolbar, look for the icon that looks like two arrows meeting at a bar. Click it for Merge all. Click the small dropdown arrow next to it to choose Merge horizontally/vertically/Unmerge.
When merging cells with different values, only the top-left survives. The rest is discarded. To preserve values, concatenate first: =A1&" "&B1&" "&C1 — then merge the result.
How to unmerge
Click the merged cell
Select the cell that's currently merged.
Click Format → Merge cells → Unmerge
Or click the toolbar merge button (toggles between merge and unmerge). The cell splits back into individual cells; the value stays in the top-left.
Why merging is generally a bad idea
Merged cells break Sheets functionality in ways that seem fine until they aren't:
- Sorting breaks. Sheets refuses to sort a range containing merged cells.
- Filters get weird. Filtered rows may hide merged cells partially, causing display issues.
- Formulas struggle. Cross-cell references and array formulas often fail near merges.
- Copy-paste doesn't behave as expected. Merged cells may or may not paste correctly.
- QUERY function errors. Merged cells can cause QUERY to return wrong results.
Instead of merging, put text in a single cell and use horizontal alignment to center it visually. Row height changes and thicker borders create the "merged" look without any of the merging problems. See our conditional formatting guides for more visual techniques.
Common gotchas
- Only adjacent cells can merge. Non-contiguous selections (Ctrl+click ranges) won't merge.
- Merged cells break IMPORTRANGE. Data pulled via IMPORTRANGE may look off if the source has merged cells.
- Frozen row + merged cell interaction is buggy. Avoid merging in frozen regions.
- Locked ranges prevent merging. If the range is protected, unprotect it first.
Sheets Wizard — better visual formatting without merge cell pain
Merged cells break things. Sheets Wizard's AI can generate the same visual result — headers spanning columns, categorized sections, hierarchical layouts — using proper formatting techniques (horizontal alignment, borders, conditional formatting) that don't break sorting, filtering, or QUERY. Ask "make row 1 look like a section header" and Wizard picks the right technique.
Install Sheets Wizard →Frequently asked questions
How do I merge cells in Google Sheets?
Select adjacent cells. Click Format → Merge cells → Merge all. Or use the merge icon in the toolbar (looks like two arrows meeting). If cells contain data, only the top-left value is kept.
What's the difference between Merge all, Merge horizontally, and Merge vertically?
Merge all combines the entire selection into one cell. Merge horizontally merges each row separately (columns collapse, rows stay separate). Merge vertically merges each column separately (rows collapse, columns stay separate). Merge all is the most common; horizontal/vertical are useful for creating spanned headers across multiple rows.
How do I unmerge cells in Google Sheets?
Click the merged cell. Then click Format → Merge cells → Unmerge. Or click the toolbar merge button (it toggles when a merged cell is selected). The cell splits back into individual cells with the value in the top-left.
Why is Merge cells greyed out?
Common reasons: (1) The selected range is inside a filter view — turn off the filter first. (2) The sheet has protection preventing structural changes. (3) You've selected non-adjacent cells (Ctrl+click ranges). (4) You're trying to merge cells inside a pivot table. Ensure your selection is a contiguous, editable range.