How To Merge Cells In Google Sheets

Are you exploring to know how to merge cells in google sheets? Merging cells in Google Sheets is a great method to hold your spreadsheet well-organized and simple to understand. The general use is for headers to classify content across multiple columns, but despite the reason, it’s an easy process.

Fire up your browser and start to the Google Sheets home page. Once there, open up a spreadsheet that includes data that requires merging. Highlight the cells you want to merge.

How To Merge 2 Cells In Google Sheets
How To Merge 2 Cells In Google Sheets

How to Merge Cells In Google Sheets 

The easiest way is to learn by doing:

Let’s state you have one central header (2019) and six subheaders (Jan, Feb, March, April, May, and June). If you need your main heading to span across several adjacent cells (as shown in the example below), you need first merge them.

How To Merge Two Cells In Google Sheets
How To Merge Two Cells In Google Sheets

Merging Cells in Google Sheets 

  1. Head, you’ll have to select the cells that you want to merge.
  2. You should then leave-click on the Format tab, choose Merge Cells from the drop-down menu, or click on the Merge button in your toolbar.
  3. There you’ll see several options you can use to merge cells – Merge all, Merge horizontally or Merge vertically, depending on the cells that you’ve chosen. (PSSST. If some cells that you selected had already been merged, the Unmerge option will also be available for you to use.)
  4. Please choose one of the merge options mentioned above, and that’s it! All chosen cells will be instantly merged according to the option you had selected.

Merge Cells Options Available in Google Sheets

When merging cells in Google Sheets, there are three diverse options:

  1. Merge all – Utilize this option for merging adjacent cells into one (if you select non-contiguous cells, this option will not be possible for you to use).
  2. Merge horizontally – Utilize this option for merging horizontal cells into one (even if you choose cells across two or more rows, it will just mix the horizontal ones).
  3. Merge vertically – Utilize this option for merging vertical cells into one (even if you choose cells across two or more columns, it will just mix the vertical ones).

However, keep in mind that the merged cell will retain the value only from the top-left cell when you merge several different cells into one. If there were any data in cells apart from this one, you’d see the same prompt that’s shown below.

Unmerging Cells in Google Sheets

If you no longer need your cells to be merged, you can easily unmerge them.

  1. Head, you’ll have to select the cells that you want to unmerge.
  2. You should then leave-click on the Format tab, choose Merge Cells from the drop-down menu, or click on the Merge button in your toolbar.
  3. There you’ll see the Unmerge option. Hit on it, and all the chosen cells will be instantly unmerged.

How to Merge Cells in Microsoft Excel

While the method for merging cells in Google spreadsheets is slightly different from doing so in Excel, they are pretty similar.

Step 1: Open your Excel spreadsheet.

Step 2: Apply your mouse to select the cells that you wish to merge.

Step 3: Hit the Home button at the top of the window.

Step 4: Click the Merge &Center button in the ribbon’s Alignment section, then choose the preferred merge option.

How to Merge Cells in the Google Docs

The process earlier will let you combined cells in Google Sheets, but you may view yourself working in a Google Docs table rather. You can see the steps below to merge cells there.

Step 1: Start your Google Docs file containing the table.

Step 2: Hit inside the first cell that you wish to merge, then hold down your mouse key and choose the rest of the cells to merge.

Step 3: Right-click on one of the chosen cells, then choose the Merge cells option.

How to Combine Text into a Cell

To merge text from two or more cells into a single cell, use the CONCATENATE function, which you may enter in Google Sheets on the web as great as the mobile apps. This lets you specify source cells and add text and or separators before, between, or after the cells you choose to combine.

For instance, I applied the concatenate function in an application feature comparison spreadsheet. One column included feature names, while another column contained application details. I mixed these and added a colon separator, then copied that lines into a Google Doc, with the following function:


This uses the contents of A3, adds a colon and space, followed by the contents of cell B3. The combined contents are located in the cell where I entered the function (i.e., cell C3). Define cells by entering the cell references, separated by commas, and circle any spaces and separators you wish to add with quotes.

Merging Cells in Google Sheets – Tips

  • Using the above methods to merge cells in Google Apps and Microsoft Excel will combine both the cells themselves and their data. You can use something called the Concatenate formula in Excel if you only wish to merge the cells’ data.
  • The merge choices in Google Sheets can be suited to entire rows and columns as well. For example, if you selected column A and column B in your spreadsheet, you clicked the Merge icon and set the Merge horizontally option. Sheets would automatically merge across every row in those columns and leave you with an entirely new column of individual cells that spanned two columns.
  • Issues when merging cell in Google Sheets
  • While working on merged cells, there are a few stuff you need to know.
  • Unable to Sort Columns with Merged Cells: The first issue with merge cells is that. You can’t sort a column that has merged cells.
  • Copies merged cells and not the value: If you have three cells combined with any text in it and copy and paste this somewhere else in the worksheet, the result would be merged cells (with the corresponding text and formatting).
  • For instance, you only want to copy and paste the content of the merged cells and not get the result which itself are merged cells, you require to copy and then paste as value. You need to keep in mind a few issues when working with merged cells in Google Sheets.
43 thoughts on “How to Merge Cells in Google Sheets – Step by Step Guide”
  1. What’s Happening i’m new to this, I stumbled upon this I’ve discovered It positively useful and it has aided me out loads.

    I hope to give a contribution & help different customers
    like its helped me. Good job.

    1. Much appreciated !! this provide boast and help to do more efforts then the last time. Thanks once again.

  2. I don’t even know how I ended up here, but I thought this post was good.
    I don’t know who you are but definitely you’re going to a famous blogger if you are not already
    😉 Cheers!

  3. What’s up everyone, it’s my first pay a visit
    at this web page, and post is in fact fruitful in favor of me, keep up posting these types of content.

    1. We are welcoming you for your first visit here.
      We Glad to hear that you came and like our work.
      Search for more and fine some relevant topics as per your desire.

  4. Nicce answers in return of thi query with genuine
    arguments and explaining the whole thiing regarding

  5. I do not even know how I ended up here, but I assumed this submit was good.
    I don’t know who you might be but definitely you’re going to a well-known blogger for those
    who are not already. Cheers!

    1. Thanks a lot , This work line fuel for engine for us. Keep connect and let us aware of your opinion and suggestion . We love to hear back from you.

  6. Good way of explaining, and fastidious post to take data concerning my presentation subject matter, which i am going to present in school.

  7. I do agree with all the concepts you’ve offered for your
    post. They’re really convincing and will certainly work.
    Nonetheless, the posts are very short for novices. May just you please prolong
    them a bit from next time? Thank you for the post.

  8. Hurrah! At last I got a webpage from where I can truly obtain useful facts concerning
    my study and knowledge.

    1. If you need you can have more other topics which also might be relates to you niche.
      And if you have any topic in you mind do share that with us.

      Thanks you.

  9. I think this is among the most important information for me.
    And i am glad reading your article. However wanna remark on some general issues,
    The website style is wonderful, the articles is really excellent : D.
    Excellent job, cheers

  10. Hello, i believe that i saw you visited my blog thus i came to
    go back the prefer?.I’m attempting to find issues to enhance my web site!I guess its
    adequate to use a few of your ideas!!

  11. Greetings from Florida! I’m bored at work so I decided to check out your site on my iphone during
    lunch break. I really like the info you provide here and can’t wait to take a look
    when I get home. I’m shocked at how quick your blog loaded
    on my phone .. I’m not even using WIFI, just 3G ..
    Anyways, good blog!

  12. If some one wishes expert view concerning blogging then i recommend him/her to pay a
    quick visit this weblog, Keep up the fastidious work.

  13. Everything is very open with a really clear explanation of the
    issues. It was definitely informative. Your site is extremely helpful.
    Thanks for sharing!

  14. Excellent way of explaining, and good piece of writing to get data regarding my presentation focus,
    which i am going to convey in university.

  15. I’m not that much of a online reader to be honest but your blogs really nice, keep it up!
    I’ll go ahead and bookmark your site to come back down the road.
    All the best

  16. Excellent article. Keep writing such kind of information on your blog.
    Im really impressed by your blog.
    Hi there, You’ve performed a great job. I’ll certainly
    digg it and in my opinion suggest to my friends.
    I’m sure they will be benefited from this website.

    1. That’s very kind , we are working more hard to get more attention . You surely will find more relevant topics.

  17. Aw, this was a very good post. Finding the time and actual
    effort to create a very good article… but what can I say… I put things off a lot and don’t seem to get nearly anything done.

Leave a Reply

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