How to Merge Cells in Google Sheets

This guide is going to show you how to merge cells in Google Sheets.

  1. Sign into and open the file containing the cells you want to merge.
  2. Select the cells to merge.
  3. Click the arrow to the right of the Merge cells button.
  4. Select the way that you wish to merge the cells.
How to merge cells in Google Sheets

The ability to merge cells in Google Sheets is an option that you may be familiar with if you have worked with Microsoft Excel.

While the traditional method for entering data in a spreadsheet involves typing data into cells that are organized into rows and columns of equal size, your layout may require you to combine a couple of cells into one larger cell.

This is common if you are breaking up your spreadsheet into sections, or if you are using Google Sheets to make something like an order form.

Google Sheets gives you the option to merge your cells in a handful of ways, which are:

  • Merge all
  • Merge horizontally
  • Merge vertically

Any merge option that you choose can be undone by selecting the merged cell, clicking the arrow next to Merge cells, then choosing the Unmerge option.

Find out about freezing a row in Google Sheets if you need to keep one of your spreadsheet rows visible at the top of the screen.