How to Merge Cells in Google Sheets

Sometimes when you are adding data to spreadsheets, you might discover that you have placed content in multiple cells when it would be terr if it were in one.

You might have considered trying to fix this manually, but that can be tedious and time-consuming.

Luckily there is a tool in Google Sheets that you can use which can make this process a little simpler.

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
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.

Now that you know how to merge cells in Google Sheets you can use these steps if you have data in multiple cells that you would prefer to display in just one cell.

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.

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy