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.
- Open the Sheets file containing the cells to merge.
Visit https://drive.google.com to view your files.
- Select the cells to merge vertically.
- Click the “Merge cells” button in the toolbar.
- Choose the “Merge vertically” option from the dropdown menu.
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 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.