How to Merge Cells in Google Sheets

Written by Coursera Staff • Updated on

Need to combine cells in Google Sheets? Follow this quick guide to merging cells and when to use this function.

[Featured Image] A man works on a laptop at a desk while wearing headphones.

To combine two or more cells in Google Sheets, you can use the merge function. This is typically used for formatting your data. Once you merge cells, data analysis can become tricky because it limits the functionality for sorting, copying, pasting, and moving data, so it is most often used for aesthetic purposes.

How to merge cells

Here's a quick summary of the steps you'll take to merge cells:

  1. Highlight the cells that you want to merge. 

  2. Go to Format in the top menu.

  3. Hover over Merge cells and choose a merging method.

Let's take a closer look at each step.

Ready to deepen your knowledge of Google Sheets?

To begin, you'll need your tab open to your spreadsheet. If you’re not already working with your own data set and want to follow along with our examples, make a copy of this Google Sheets template to practice.

Placeholder

1. Highlight the cells that you want to merge. 

The example below is for combining the three “Director” columns into one. This makes the data look cleaner and indicates that each name in these columns falls under the directory category.

Alt text: Highlighted cells to merge displayed in Google Sheets

2. Go to 'Format' in the top menu. 

Click on the Format tab and a list will drop down.

Alt text: Format tab drop-down menu displayed in Google Sheets.

3. Hover over 'Merge cells' and choose a merging method.

Your options are Merge all, Merge vertically, or Merge horizontally. Click on the one that suits your needs. In this example, we will select Merge horizontally.

Alt text: Merge cells selected in Format drop-down menu displayed in Google Sheets.

Your cells will merge into one cell titled Director (1). You can format this merged cell however you like. In this example, we removed the (1) and center aligned the text. It will look like this:

Alt text: Cells merged into one cell titled Director displayed in Google Sheets.

Which way to merge?

You have three options for the merge function. “Merge all” will combine all highlighted cells into one cell, as seen above. “Merge vertically” will just merge cells in each column if you highlight multiple columns, which you might use if you want to create columns (without data). “Merge horizontally” will merge cells in each row for your selected rows. You might use this function if you have several rows of titles for your data. Learn more: How to Highlight Duplicates in Google Sheets

Placeholder

How to unmerge cells in Google Sheets

To unmerge your cells, simply highlight the merged cell. Then, go to Format > Merge cells > Unmerge. The combined cells will become single cells again.

Common errors when merging cells

If you try to merge several cells that each have text inside of them, then only the top-leftmost value will stay and become the main text in the merged cell. An error message will appear asking whether you want to merge anyway. You can click the “OK” button or proceed to cancel.

Limitations and alternatives

Merging cells can be problematic if you are analyzing data. Merged cells may not be picked up when you sort, copy, paste, or move data, so you will end up losing data integrity of the rows and columns, which could lead to inaccuracies. To avoid this, use the merge function only for improving the aesthetics of your sheet, or else you could risk losing important data.

Learn more with Google

Interested in strengthening your abilities to work with data using Google Sheets? Enroll in the Google Data Analytics Professional Certificate. You’ll learn more about spreadsheets and other key analysis tools.  

Keep reading

Updated on
Written by:

Editorial Team

Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact...

This content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.