Merging cells in Google Sheets is meant to be a quick menu command. This article gives you the path one published guide describes and flags what isn't confirmed yet, so you can merge without surprises.
The menu path one guide describes
According to Formester's guide to merging cells in Google Sheets, you select the cells you want to combine and go to Format > Merge cells. The guide lists three options in that menu:
- Merge all
- Merge horizontally
- Merge vertically
The same guide says you unmerge from that same Format > Merge cells menu.
That is a third-party blog post, not Google's documentation. This article has not confirmed those menu names against Google's own help or a second independent source. If what you see in your menu differs, trust your screen over this summary.
Protect data in the other cells before merging
The biggest risk with merging is losing content. When several cells each hold a value and you merge them, a spreadsheet may keep only one of those values. Sheets Bootcamp's guide to merging cells covers how Google Sheets handles this, so read it before merging cells that hold data.
To be safe:
- Merge only cells where just one cell holds data, if you can.
- If several cells hold values you need, copy them somewhere else before merging.
Some guides cover merging while keeping values, such as this InfoInspired post on preserving values when merging and unmerging. This article hasn't verified its method, so test it on a copy of your sheet first.
If you're merging text from several cells into one so you can split it again later, the split text guide for Google Sheets covers the reverse task.
Merging cells in a Google Docs table is a different job
Formester's guide also says that in Google Docs you can merge cells only inside a table. That's a separate feature from Sheets, and its steps aren't confirmed here either.
Other guides to compare against
If you want a second opinion before merging an important sheet, these third-party guides cover the same topic. None of them has been checked for this article, and none is official:
- Ablebits on merging cells in Google Sheets
- Kieran Dixon's merge cells guide
- Sheets Bootcamp on merging cells
- Coursera's merge cells tutorial
Where two guides disagree with each other or with your menu, Google's own Docs Editors Help is the source to follow.
Merged cells can also get in the way of sorting and cleanup tasks such as removing duplicates in Google Sheets, so it can help to unmerge before running those.