• Home

  • Productivity

  • App tips

App tips

2 min read

How to merge cells in Google Sheets

By Jessica Lau · January 19, 2024
A hero image for Google Sheets app tips with the Google Sheets logo on a green background

When working with large datasets in Google Sheets, combining cells is an effective way to organize and present your data. Whether you're adding a headline for a report, formatting a to-do list, or just trying to make your spreadsheet less of an eyesore, here's how to merge cells in Google Sheets. 

Here's the short version, but for a step-by-step guide with screenshots, keep scrolling. 

  1. Highlight the cells you want to combine. 

  2. Click Format > Merge cells > Merge all. Or click the Merge cells icon in your toolbar. 

Table of contents:

  • How to merge cells in Google Sheets from a desktop

  • How to merge cells in Google Sheets on the mobile app

How to merge cells in Google Sheets from a desktop 

Let's use this simple student grade sheet as an example. The headline TESTS in cell D4 gives the impression that it applies only to column D. To make it clear that there are five tests (columns D to H), I want to merge cells D4 to H4. 

Student grade sheet in Google Sheets.
  1. Highlight the cells you want to combine.

  2. Click Format > Merge cells > Merge all

    How to merge cells in Google Sheets using the format dropdown.

    Alternatively, click the Merge cells icon in the toolbar. 

    How to merge cells in Google Sheets using the merge cells button in the toolbar.

That's it. Google Sheets also automatically realigns text to the middle of your combined cells. And if you applied a fill color to the original single cell, as I did in my example, it'll apply the same fill to your combined cells. 

Merged cells in Google Sheets.

Note: If two or more cells in your selection contain data, Google Sheets will preserve only the value in the top-left cell. For example, If cell D4 contained the value TESTS and cell E4 contained WORDS, only TESTS would appear after I merged the cells.

Need to unmerge cells? The easiest way to do this is to click anywhere in the combined cells, and then click the Merge cells icon in your toolbar. It's worth noting, though, that if you unmerge cells that share a fill color, all your newly unmerged cells will retain that fill color.

Demo of what happens to the cell fill color when you unmerge cells in Google Sheets.

How to merge cells in Google Sheets on the mobile app 

I can't think of a single reason that would compel me to squint at Google Sheets on my phone (it's awful), let alone try to edit it from a palm-sized device. But we're not here to talk about me. Here's how to merge cells in Google Sheets on the mobile app. (I use an iPhone, but the same method works for Android, too.)

  1. Highlight the cells you want to merge.

    Spreadsheet in the Google Sheets mobile app.

  2. Tap the Merge cells icon in the toolbar. 

    Merged cells in the Google Sheets mobile app.

You're all set. 

Automate Google Sheets

Editing Google Sheets from your phone—I mean, manual data entry—is ripe for human error. With Zapier, you can connect Google Sheets with your other apps. This way, you can automate your most time-consuming spreadsheet-related tasks.

For example, you can automatically notify your teammates whenever you make updates to your spreadsheet. Or turn new rows of data into tasks in your project management app. Learn more about how to automate Google Sheets, or get started with one of these workflow templates.   

Post to Microsoft Teams channels with new or updated Google Sheets rows

Post to Microsoft Teams channels with new or updated Google Sheets rows
  • Google Sheets logo
  • Microsoft Teams logo
Google Sheets + Microsoft Teams

Send Slack messages whenever Google Sheets rows are updated

Send Slack messages whenever Google Sheets rows are updated
  • Google Sheets logo
  • Slack logo
Google Sheets + Slack

Create Trello cards from new or updated Google Sheets rows

Create Trello cards from new or updated Google Sheets rows
  • Google Sheets logo
  • Trello logo
Google Sheets + Trello

Create Asana tasks from updated Google Sheets rows

Create Asana tasks from updated Google Sheets rows
  • Google Sheets logo
  • Asana logo
Google Sheets + Asana

To get started with a Zap template—what we call our pre-made workflows—just click on the button. It only takes a few minutes to set up. You can read more about setting up Zaps here.

Related reading:

  • How to freeze columns in Google Sheets

  • How to split text in Excel and Google Sheets

  • Google Sheets functions that do more than math

  • How to use conditional formatting in Google Sheets

  • How to wrap text in Google Sheets

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

tags
mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign up
See how Zapier works
A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'