How to merge & unmerge cells in Google Sheets – 3 ways!

by Sharon

There are times when you want text to be spread over a number of columns or rows – for example you may want the title to span the width of the table. In this step-by-step tutorial I show you how to merge selected cells horizontally, vertically, or both, as well as how to unmerge cells. If you prefer to watch the video, scroll down to the end of this post 🙂

Whilst merging cells is a great formatting tool to make text look better, it is not recommended to merge cells containing data in a dataset, as it can get a bit messy when it comes to data analysis!


Where to find the Merge cells option

Once you have highlighted the cells you want to merge, there are 2 ways to find the Merge cells option:

Option 1

Click on Format in the menu, go down to Merge cells, and select one of the options available to you (depending on the cells highlighted)…


Format menu

Option 2

Click on the Merge cells button on the quick access toolbar…


toolbar

Word of warning!

If you try to merge cells that contain data in more than 1 cell, like the example below…



…then you will get the following warning, meaning that only the number 1 will be kept in the example above once the cells are merged…



Below are the 3 different types of merges available in Google sheets:


Merge horizontally

Use this to merge cells across a row (or rows) horizontally…


horizontal merge

Merge vertically

Use this to merge cells down a column (or columns) vertically…


merge vertically

Merge all

Use this to merge all the cells in your selected range into one single cell…



How to unmerge cells

Select the cells you want to unmerge and either click on Format, Merge cells and then Unmerge


unmerge

OR click on the Merge cells button on the quick access toolbar, and select Unmerge



And that’s how to merge and unmerge cells in Google Sheets – I hope you have found it helpful 🙂

You may also like

2 comments

Lupin 30/09/2021 - 7:09 pm

You 100% deliver on explaining how to do different tasks without the confusing jargon. Thank you so much!

I am visually impaired so spreadsheets have definitely not been my favorite thing, but I’ve been trying to utilize them more as I expand my freelance writing gigs, and all of the articles on your website have been super helpful. thanks for providing stuff in a text, photo, or video format; makes your explanations very accessible whether I am on my phone or magnifying some thing on my computer to get a closer look.

Reply
Sharon 01/10/2021 - 8:05 am

Thanks so much for your comment – it means a lot that you find my tutorials so helpful. I try to make them as straight forward as I can using a lot of screenshots. If there’s anything else you’d like me to cover regarding spreadsheets (Excel or Google Sheets), please let me know. Thanks again, Sharon.

Reply

Leave a Comment

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

This website uses cookies to improve your experience. I'm assuming you're okay with this, but you can opt-out if you wish. Accept Read More