---
title: "How to merge cells in Google Sheets"
description: "When working with large datasets in spreadsheets, combining cells is an effective way to organize your data. Here's how to merge cells in Google Sheets."
image: "https://images.ctfassets.net/lzny33ho1g45/1d2ScS0XusebtTq7GvoL2T/783a6630bf45516429baa1a4e7ba4711/google-sheets-app-tips.jpg"
---

# How to merge cells in Google Sheets

When working with large datasets in spreadsheets, combining cells is an effective way to organize your data. Here's how to merge cells in Google Sheets.

When working with large datasets in [Google Sheets](https://vendors.selectsoftwarereviews.com/redirect/1767831752373x549042478702919700?p=1715808885462x244895206427328500), 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](https://zapier.com/blog/google-sheets-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](#desktop)
- [How to merge cells in Google Sheets on the mobile app](#mobile)

## 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. 

1. Highlight the cells you want to combine.
2. Click **Format** > **Merge cells** > **Merge all**.

Alternatively, click the **Merge cells **icon in the toolbar.

That's it. [Google Sheets](https://zapier.com/blog/google-sheets-tutorial/) 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. 

**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.

## 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.

2. Tap the **Merge cells** icon in the toolbar.

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](https://zapier.com/apps/google-sheets/integrations) 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](https://zapier.com/blog/automate-google-sheets/), or get started with one of these workflow templates.   

**Related reading:**

- [How to freeze columns in Google Sheets](https://zapier.com/blog/how-to-freeze-columns-google-sheets/)
- [How to split text in Excel and Google Sheets](https://zapier.com/blog/split-text-excel-zapier/)
- [Google Sheets functions that do more than math](https://zapier.com/blog/google-sheets-functions/)
- [How to use conditional formatting in Google Sheets](https://zapier.com/blog/conditional-formatting-google-sheets/)
- [How to wrap text in Google Sheets](https://zapier.com/blog/how-to-wrap-text-google-sheets)