How to Merge Cells Vertically in Google Sheets

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