• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Google Sheets: How to Easily Merge Cells

Google Sheets: How to Easily Merge Cells

Posted on July 29, 2022 by Judy Sanhz Leave a Comment

There will come a time when you might need to merge cells in Google Sheets. Something at work might require that you do this, and the good news is that it can be done on your computer or Android device. Keep reading to see how you can merge cells in Sheets on both devices.

How to Quickly Merge Cells in Google Sheets

Once you have the file open that has the cells you want to merge, select the cells. You can choose the cell by clicking on one and pressing Ctrl, followed by the other cell. Once the cells are highlighted, click on the Format tab at the top. Place the cursor on the Merge Cells option, and more options appear.

Using the keyboard shortcut Alt + O + M for Windows, you can also get here. By pressing only Alt + O, you’ll only open the format menu, but it won’t select anything. If you continue by pressing the M, that selects the Merge Cells option. By pressing Enter, you choose the Merge All option.

Google Sheets Merge Cells

Note: When you merge cells, the data in the right cell will be lost. You’ll need to enter a function if you want to keep the data on both cells. You can read how to enter this further down.

You have different options to choose from. If you select the Merge All option, it’ll do just that merge horizontal and vertical cells. The Merge Horizontally option will merge rows. If you ever change your mind and want to unmerge anything, you’ll only need to follow the same steps you followed to merge them in the first place and use the Unmerge option. It will be the last one on the list. Google Sheets will show you a warning message when you choose an option. If you’re sure of what you’re merging, click on the green OK button.

After merging the cells, you’ll notice that the only text remaining is the text from the cell on the left. You can always center the text if you want to make it look nice. You can do this by clicking on the Horizontal Align option at the top and choosing the center option.

Center text Google Sheets

How to Keep Data of Both Google Sheet Cells

As I mentioned before. When you use the Merge All option, the only data you’ll keep is the data that was in the left cell. But, there is a way to merge and save the data of both cells. To do this, you’ll need to enter the =CONCATENATE () function.

Enter the equal sign on the cell where you want the merged data to appear and start typing CONCATENATE. After a few letters, you should see the option appear in the list of options; choose it. Click on the first cell and then enter a comma. Click on the second cell and enter a closing parenthesis; press Enter. You should now see the data that was on both cells in one.

Google Sheets Function

How to Merge Cells in Google Sheets on Android

Since you’re not always on your computer, it’s also good to know how you can merge cells in Google Sheets on your Android device. Once you have the file open, tap on the first cell you want to merge and drag the blue circle from the corner of the cell to choose the second cell. Tap on the Merge Cells option at the bottom that’s going to look like two arrows pointing at each other. You’ll see a warning message. Tap OK to continue.

Google Sheets Merge Cells Android

Conclusion

That’s all you need to do when merging the cells on your Android device or your computer. The process is more comfortable from your computer, but now you know the steps for Android if it’s ever necessary. How often do you have to merge cells on Google Sheets? Let me know in the comments below, and don’t forget to share the article with others on social media.

You Might Also Like

  • Google Sheets: Set Cells to Same Size
    Google Sheets: Set Cells to Same Size
  • Google Sheets: Protect Cells
    Google Sheets: Protect Cells
  • Google Sheets: Remove Formatting From Cells
    Google Sheets: Remove Formatting From Cells
  • How to Merge Sheets in Excel
    How to Merge Sheets in Excel
  • Google Docs: How to Easily Add an Image Watermark
    Google Docs: How to Easily Add an Image Watermark
  • Google Drive: How to Easily Create and Share a Folder
    Google Drive: How to Easily Create and Share a Folder
  • How to Easily Create a Locked Folder in Google Photos
    How to Easily Create a Locked Folder in Google Photos
  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • What Is an Internal Speaker?
  • Google Keep: How to Share Your Notes with Someone
  • Google Docs: How to Use Find and Replace
  • Google Docs: How to Use Page Breaks
  • How to Use Pageless Format in Google Docs
  • Google Sheets: How to Easily Merge Cells
  • What is Overvolting?
  • What Is Denial of Service?

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2022 Technipages · All Rights Reserved · Privacy