How to Merge Cells in Google Sheets

How to merge

1. Select the cells you want to merge. They must be adjacent.
2. Format → Merge cells, then choose an option.

Option	Result
Merge all	The whole selection becomes one cell
Merge horizontally	Each row merges separately — 3 rows stay 3 cells
Merge vertically	Each column merges separately
Unmerge	Splits it back apart

Merge horizontally is the one people actually want when applying a heading to several rows at once. Merge all would collapse them into a single cell and destroy the rows.

What happens to your data

Only the value in the top-left cell is kept. Everything else in the selection is deleted.

Sheets warns you when the other cells contain data, and the warning is easy to click past. Once merged and saved, the discarded values are gone — Ctrl + Z works during the session, but not after you close the file.

If you are merging to combine text rather than to format a heading, merging is the wrong tool entirely. Use a formula:

• =A1&" "&B1 joins two cells with a space
• =TEXTJOIN(" ", TRUE, A1:C1) joins a range, skipping empties

That keeps every value and puts the combined result in a new cell.

What merged cells break

This is why experienced spreadsheet users avoid merging inside data ranges.

• Sorting. Sheets refuses to sort a range containing merged cells, and the error does not explain which cells are the problem.
• Filtering. Filters behave unpredictably — a merged cell belongs to one row as far as the filter is concerned, so rows visually under it get hidden or shown incorrectly.
• Formulas across the range. A merged block reports the top-left address only, so COUNTA and similar functions count it once regardless of how many cells it spans.
• Copy and paste. Pasting into a differently shaped merged area fails or overwrites unexpectedly.
• Pivot tables. Merged cells in the source produce blank or misaligned headers.

The rule: merge in headings and layout, never inside a table you will sort, filter or analyse.

Better alternatives for the common cases

To make long text readable

Use Format → Wrapping → Wrap instead. The text stays in one cell and flows onto multiple lines, with no effect on sorting or filtering. This solves what most people are actually trying to fix when they reach for merge.

To make a column wide enough

Just widen the column — drag its right-hand border, or double-click that border to fit the content automatically.

For a title above a table

Put the title in a cell in a row above the data, outside the range you will sort. Increase its font size and leave a blank row between the title and the headers. It looks the same and breaks nothing.

Note that Sheets has no equivalent of Excel's "Center Across Selection", the option that centres text visually without actually merging. In Sheets, merging horizontally is the closest thing — which is exactly why keeping titles outside the data range is worth the habit.

Finding merged cells that are causing errors

When a sort fails and you cannot see why, merged cells are usually hidden somewhere in the range.

The quickest way to find them: select the whole range and apply Format → Merge cells → Unmerge. This unmerges everything in the selection and does nothing to cells that were never merged, so it is safe to run on a whole sheet.

You will need to re-apply any formatting you actually wanted, but the sort will work again.

Does this match Excel?

	Google Sheets	Excel
Merge options	All, horizontally, vertically	Merge & Center, Across, Cells
Keeps only top-left value	Yes	Yes
Breaks sorting	Yes	Yes
Center Across Selection	Not available	Available

The behaviour is otherwise the same, so a file merged in one opens with the merges intact in the other.

If merging was an attempt to tidy a sheet, drop-down lists often do more for consistency, and formulas not updating covers the other common Sheets surprise.

Frequently asked questions

How do I merge cells in Google Sheets?

Select the cells, then Format → Merge cells → Merge all, or use the merge button in the toolbar. Merge horizontally merges each row separately; merge vertically does the same per column.

What happens to my data when I merge cells?

Only the top-left value is kept and everything else is deleted. Sheets warns you first, but once saved the discarded values cannot be recovered. To combine text instead, use =A1&" "&B1 or TEXTJOIN.

Why can't I sort my data?

Almost always merged cells somewhere in the range. Select the whole range and use Format → Merge cells → Unmerge; it is safe on cells that were never merged and will let the sort run.

How do I unmerge cells?

Select them and choose Format → Merge cells → Unmerge. The original value stays in the top-left cell — the values that were discarded when merging do not come back.

How do I make text fit without merging?

Use Format → Wrapping → Wrap so the text flows onto several lines within one cell, or widen the column by double-clicking its right-hand border. Neither affects sorting or filtering.

Does Google Sheets have Center Across Selection?

No. Excel has that option, which centres text visually without merging, but Sheets does not. The practical alternative is to keep titles in rows outside the data range so merging is unnecessary.

Can I merge cells that are not next to each other?

No. Merging only works on an adjacent, rectangular selection. To apply the same look to separate areas, merge each one individually.

Conclusion

Format → Merge cells → Merge all, remembering that only the top-left value survives.

The more useful habit is knowing when not to merge. Inside a table you intend to sort or filter, merged cells cause problems that are hard to trace back later — wrapping text or widening the column solves the real need without any of that.

Related: Google Sheets formulas not updating covers recalculation, and highlighting duplicates in Sheets covers conditional formatting.