How to Merge Cells in Google Sheets and Avoid the Traps

Merging cells is the spreadsheet equivalent of centring a heading over a whole table. It makes titles, report headers and tidy-looking schedules possible. It's also one of the easiest ways to break a sheet, because merged cells and sorting don't get on.

So here's how to merge cells in Google Sheets, what Google's help does and doesn't say about it, and when I'd leave merging alone entirely. If you run a small business and share spreadsheets with a team, the last bit might save you some grief.

Merging cells in Google Sheets on a computer

Google's help gives a short set of steps:

1. Open your spreadsheet in Google Sheets.
2. Select the cells, rows or columns you want to merge.
3. At the top, click Format.
4. Click Merge cells.
5. Select how you want your cells to be merged.

That last step is a menu of choices. Google's page says to pick how you want the cells merged but doesn't spell out each option, so read the labels in your own menu and choose the one that matches your selection. Menus vary by version, and it's easy to undo a merge straight away if it isn't what you wanted.

Merging a title across the top of a Google Sheets table

This is the job most people are really doing. You've got a table with several columns and want one heading sitting across all of them.

1. Type the heading in the first cell of the row above your table.
2. Select that cell and the cells to its right, across the width of the table.
3. Go to Format, then Merge cells and choose the merge that joins the selection.
4. Use the alignment buttons in the toolbar to centre the text.

Keep it to headings. For anything that holds data, merged cells tend to cause trouble later, which I'll come to in a moment.

Merging rows or columns in Google Sheets as well as single cells

The help page's introduction says you can freeze, group, hide or merge your spreadsheet's columns, rows or cells. The steps are the same: select what you want to merge and use Format, then Merge cells. Pick your selection carefully, because a large selection gives you a large merged block.

Checking your data before you merge cells in Google Sheets

Google's merge page doesn't explain what happens to values sitting in the cells you're joining, and I don't want to claim details it doesn't state. So treat the data in a merge selection as something to protect:

• Copy the original cells to a spare column or tab first.
• Read any message Sheets shows before you confirm the merge.
• Merge empty cells where you can, such as heading rows with the text in one place only.
• Use a separate cell for anything you'll need to look up later.

If you're pulling a customer list or product table together, the layout advice in my guide to what to look for in a productivity template is worth a read before you start formatting.

Why merged cells in Google Sheets can stop sorting and filtering

This is the trap. In Google's help for sorting and filtering, when the Create a filter option is unavailable, one of the things to check is merged cells. The advice is to unmerge them and unhide any hidden rows or columns, then try again.

Problem	What Google's help suggests
Create a filter is unavailable	Check for merged cells and hidden rows or columns, then unmerge and unhide
Still stuck	Check conditional formatting and data validation rules
You can only view the sheet	Make a copy of the sheet and see whether the option works there

My rule: merge presentation areas only, such as a report heading, and keep the working data in plain, unmerged rows and columns. A tidy grid sorts, filters and copies far more easily. If you need to know more about ordering your data, have a look at my guide on filling in a Google Docs template for how I keep structured information consistent.

Undoing a merge in Google Sheets

Google's merge page I read doesn't list the unmerge step, so I'll be careful here. Start by selecting the merged cell and looking in the same Format, Merge cells menu, because menus vary and that's the first place to check. If you merged by mistake a moment ago, Undo in the Edit menu is the simplest fix.

1. Click the merged cell.
2. Open Format, then Merge cells.
3. Look for the option that separates the cells again.
4. If it isn't there, use Edit, then Undo for a merge you've just done.

Merging cells in the Google Sheets app

Google's help has Android and iPhone and iPad versions of the same article, and I couldn't read the mobile merge steps in full. Because menus vary by app version, I'd do the merge on a computer and check how it looks on your phone afterwards.

Alternatives to merging cells in Google Sheets

• Use wider columns for long headings instead of merging.
• Put the heading in the first cell and let the text spill over empty neighbours.
• Use freeze rows to keep headings visible while you scroll.

These keep the grid intact, so sorting, filtering and formulas carry on working as you'd expect.

Frequently asked questions

How do I merge cells in Google Sheets?

Select the cells, click Format, then Merge cells and choose how you want them merged. That's the route in Google's help for a computer.

Can I merge rows and columns, not just cells?

Yes. Google's help says you can merge your spreadsheet's columns, rows or cells using the same Format, Merge cells route.

Why can't I create a filter in my Google Sheet?

Google's help says to check for merged cells and hidden rows or columns, then unmerge and unhide them. Also check conditional formatting, data validation and your access.

Does Google explain what happens to data when cells merge?

The help page I read doesn't, so back up the cells before merging and read any message Sheets shows.

Should I merge cells in a data table?

I wouldn't. Keep merges to headings and leave working data in single cells, because merged cells can block filters.