Guide about Merge Cells in Google Spreadsheet [How to]

    The blog post will teach you quick and easy steps on how to merge cells in Google Sheets.

    How to Merge Cells in Google Doc - 2018

    Google Doc, a popular office suite from Google. The services offer various applications that let the user create and edit documents. Apart from them, it provides users spreadsheet app using which users can create, organize and present the tabular data.

    While creating a document sometimes users get them into the situation when they want to merge cells, but unable to do it because they don’t know the exact steps. Even lots of users are confused about the availability of functionality?

    Fortunately, the Spreadsheet app in Google Docs offers a feature using which users can merge cells, the single boxes available on the page. With the help of this function, the users can combine multiple nearby cells which in result create a single larger cell.

    Usually, the users would like to merge cells when they need a big cell in a spreadsheet. The users can do that by selecting all the cells that they want to combine by executing the Merge cells command.

    In case, you don’t know how to do that, then follow the steps discussed in upcoming lines.

    How to Merge Cells in Google Sheets

    1. Head over to the spreadsheet in which you want to merge cells. You can visit here ( if you’re going to learn how to use the function.

    2. Next, you need to Select the cells which you want to merge. It usually can be done by dragging the mouse over the cells.

    select cells in google docs
    Merge cells

    3. To merge cells, you need to take the help of Merge cell function. It is available on the Google Docs toolbar. Here’s how it looks like ” Merge cells.”

    merge cell icon in google docs

    You need to click on the down arrow next to it. The Merge cell function will show you additional options to merge cells which includes:

    • Merge All
    • Merge Horizontally
    • Merge Vertically
    • Unmerge

    Here’s how the following functions merge the cells:

    Merge All

    merge cells in google docs

    It will merge selected cells horizontally and vertically and turn them into a big box.

    Merge Horizontally

    merge cell horizontally in google docs

    It going to merge selected cell horizontally

    Merge Vertically

    merge cell vertically in google docs

    It will merge selected cell vertically

    In case, you have mistakenly join unwanted cells; then you can choose the Unmerge option. It works like an Undo feature.

    You can experiment with these options to get more out Merge cell features.

    I hope you find this blog post on how to merge cells in Google Sheets helpful. Feel free to share your thoughts in the comments.

    Viney Dhiman
    Himachali, Mechanical Engineer, Snooker Lover, Avid drinker of Scotch, Traveler, and Webmaster. (

    Recent Articles

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

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