The Reject Guide on how to merge cells in Google Sheets

Quickly merge cells in your spreadsheets.

How to Merge Cells in Google Sheets
Sponsored Message

Looking for information on how to merge cells in Google Sheets? Our complete how-to guide will help you through it step-by-step.

Merging cells in Google Sheets is a fairly easy process. But before we get into that, a bit of housekeeping…

What does merging cells do?

To “merge” two or more cells means putting them all together into one single cell.

This has a number of use-cases, but perhaps most usually it is to merge multiple columns into one. Maybe you want to group columns of data together into one pretty-looking mega-column. Regardless of what you want to achieve, merging cells should be a straightforward process.

How to merge cells in Google Sheets

Here’s how you can merge cells in Google Sheets.

1.) Go to the Google Sheets homepage and fire up your spreadsheet document.

2.) Highlight the part you wish to merge.

How to Merge Cells in Google Sheets

3.) Go to Format > Merge Cells, then select any of the following:

  • Merge All: Merges all the cells into one cell that spans the entirety of the selection, horizontally and vertically.
  • Merge Horizontally: Merges the selected cells into a row of the selected cells.
  • Merge Vertically: Merges the selected cells into a column of the selected cells.

For this example, we’ll use Merge All.

You can also skip Step 3 by using this readily available shortcut instead:

How to Merge Cells in Google Sheets

4.) That’s it, you’re done! You have successfully merged your cells in Google Sheets. Tidy up your columns by customizing the color, weight, and other aspects of the text.

How to Merge Cells in Google Sheets

Stuff to keep in mind…

Depending on the position of cells you want to merge, you might run into some errors such as this:

How to Merge Cells in Google Sheets

It’s important to note that Google Sheets will only preserve the topmost and leftmost data available in your selection. If you merge horizontally, it will only preserve the leftmost data, while merging vertically only preserves the topmost data.

How to unmerge cells in Google Sheets

If you made a mistake or want to revert your merged cells into individual cells, here’s how you can unmerge cells in Google Sheets.

1.) Highlight the previously merged part of your spreadsheet.

How to Merge Cells in Google Sheets

2.) Go to Format > Merge Cells, then select Unmerge.

You can also skip Step 3 by using this readily available shortcut instead:

How to Merge Cells in Google Sheets

4.) That’s it, you’re done! You have successfully unmerged your previously merged cells.

Over to you

That’s about it for our Reject Guide on merging cells in Google Sheets. If you have questions, chime in the comments below. For tutorial suggestions, you can drop them on there as well.