• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / How to Merge Cells Vertically in Google Sheets

How to Merge Cells Vertically in Google Sheets

June 11, 2020 By Matt Jacobs

The default grid layout of Google Sheets lets you organize data in a pattern of rows and columns. These rows and columns are evenly distributed, meaning that there is one cell from each row in each column of the spreadsheet.

But your data may not lend itself to that layout, and you might need to make a single, larger cell that spans multiple rows.

Fortunately you are able to merge cells vertically in Google Sheets using a tool found in the toolbar above the spreadsheet.

Use these steps to merge cells vertically in Google Sheets.

  1. Open the Sheets file containing the cells to merge.

    Visit https://drive.google.com to view your files.

  2. Select the cells to merge vertically.

    select the cells to merge

  3. Click the “Merge cells” button in the toolbar.

    click the Merge cells button

  4. Choose the “Merge vertically” option from the dropdown menu.

    how to merge cells vertically in Google Sheets

You can also merge cells in Google Sheets vertically by selecting the cells, then clicking Format at the top of the window, then Merge cells, and Merge vertically.

The steps in this guide were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop Web browsers as well.

You can unmerge cells by selecting the merged cells, then clicking the Merge Cells button and choosing the Unmerge option.

Additional reading

  • How to freeze a row in Google Sheets
  • Where did the gridlines go in Google Sheets?
  • How to change the date format in Google Sheets
  • How to unhide a worksheet in Google Sheets
Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

how to rotate a picture in Google Slides

How to Rotate an Image in Google Slides

How to Download a Google Slides File

How to Remove Columns in Google Docs

how to download Google Docs as a Word file

How to Download Google Docs as Word

How to Turn On or Turn Off Auto Brightness on an iPhone 7

How to Turn Off Cellular Data on an iPhone 7

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com