How to Merge Cells in Google Sheets

Merging Cells in Google Sheets on a Desktop Computer

Let’s take a simple example of a student grade sheet. The title “TESTS” in cell D4 seems to only apply to column D. To clarify that there are five tests (columns D to H), I want to merge cells D4 to H4.

Select the cells you want to merge.

Click on Format > Merge cells > Merge all.

Now, let’s learn how to merge cells in Google Sheets on the mobile app:

Merging Cells in Google Sheets on the Mobile App

Personally, I don’t see any valid reason to view Google Sheets on my phone (it’s dreadful), let alone try to edit it on a palm-sized device. But hey, we’re not here to talk about me. Here’s how you can merge cells in Google Sheets on the mobile app. (I’m using an iPhone, but the same method works for Android as well.)

Select the cells you want to merge.

Tap on the Merge cells icon in the toolbar.

And that’s it! You’re done.

Automate Google Sheets

Manually inputting data into Google Sheets from your phone is prone to human errors. With Crawlan.com, you can connect Google Sheets to your other applications and automate time-consuming spreadsheet tasks.

For instance, you can automatically notify your teammates whenever you make changes to your spreadsheet. Or convert 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.

To learn more about Google Sheets, check out these helpful articles on Crawlan.com:

Now that you know how to merge cells in Google Sheets, you can make your spreadsheets even more appealing and easy to read. Use this feature to organize your data and present your information clearly and professionally. Boost your productivity by utilizing the advanced functions of Google Sheets!