Skip to content
AnIntent

How to Merge Cells in Google Sheets: What's Confirmed So Far

The menu path one guide gives for merging and unmerging cells in Google Sheets, and what to check before you merge.

AnIntent Editorial · · 3 min read

Person working on a laptop with a spreadsheet outdoors
Photo by Gorilla ROI Data Connector on Unsplash
In this article
  1. The menu path one guide describes
  2. Protect data in the other cells before merging
  3. Merging cells in a Google Docs table is a different job
  4. Other guides to compare against
Share this article

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.

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:

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.

Common questions

Where is the merge option in Google Sheets?

Formester's guide says it's under Format > Merge cells. This hasn't been confirmed against Google's official help.

How do I unmerge cells in Google Sheets?

According to Formester's guide, you unmerge from the same Format > Merge cells menu.

Will merging cells delete my data?

Merging several cells that each hold a value can leave you with only one of them. Sheets Bootcamp's guide explains how Google Sheets handles this; copy anything you need to keep before you merge.

Can I merge cells in Google Docs?

Formester's guide says Google Docs can merge cells only inside a table. That hasn't been confirmed with Google's documentation.

Person working on a laptop with a spreadsheet outdoors
How-to

How to Freeze Rows and Columns in Google Sheets (and Unfreeze Them)

Freeze or unfreeze rows and columns in Google Sheets on a computer or Android, and when to group or hide them instead.

· 4 min

Keep reading