Skip to main content

How to merge cells in Google Sheets

Google Sheets on a laptop.
Pexels/Pixabay

If you have two or more cell sin Google Sheets that you want to combine into one, you can merge the cells with a built-in tool. This lets you merge cells horizontally, vertically, or both.

Maybe you’re worried about losing data when you merge cells in your spreadsheet. This is a legitimate concern because of the way the merge tool works. Fortunately, once you know the right way to merge cells in Google Sheets, you won't need to be concerned anymore.

Let’s look at how to merge cells in Google Sheets and options for retaining your data when you do.

Recommended Videos

Difficulty

Moderate

Duration

15 minutes

What You Need

  • PC, laptop, tablet, or smartphone with Google Sheets access.

Merge cells in Google Sheets

You may have column headers or even row headers that you want to merge into one clean cell. But you can merge any cells in your spreadsheet including cell ranges, columns, and rows. If you have locked the cells in the Sheets spreadsheet, these will need to be unlocked before merging.

Step 1: Select the cells you want to merge by dragging your cursor through them. (Note: You can only merge adjacent cells.)

Step 2: Click the Merge Cells drop-down arrow in the toolbar or Format > Merge cells from the menu.

Step 3: Choose the type of merge you want to use for your cells from these options:

  • Merge all: Merge all selected cells horizontally and vertically.
  • Merge vertically: Merge cells on top of one another.
  • Merge horizontally: Merge cells to the right and left of each other.

If an option is grayed out, then it doesn’t apply to the selected cells. For example, if you select cells in a row as in our screenshot below, you’ll only see Merge horizontally available.

Merge horizontally in Google Sheets.
Image used with permission by copyright holder

Step 4: After you choose the merge option, you’ll see your cells merged into a single cell.

Merged cells in Google Sheets.
Image used with permission by copyright holder

Step 5: When you have data in the cells you’re merging, you’ll see an alert pop up letting you know that only the data in the top-left cell will remain. If this is fine with you, click OK to continue to merge the cells.

If you prefer not to continue because you’ll lose data, click Cancel.

You can then manually combine the data or look into one of the below options for joining that data.

Merge warning in Google Sheets.
Image used with permission by copyright holder

Combine the data into a new cell

You can combine the data within cells using the ampersand operator (&) and a basic formula.

Step 1: Go to the new cell where you want to join the data and enter the cell references for the cells to combine with the ampersand between them like this:

=A1&B1

Step 2: If you want a separator between the data like a space or hyphen, you can add that to the formula like in the following:

=A1&” “&B1

Here you see a space within quotes separating the data we’ll combine.

Both formulas above combine the values from those cells together into one string.

Formula to combine cells in Google Sheets.
Image used with permission by copyright holder

Step 3: You can then replace the cell containing the data that will be retained with the results of the formula or simply use the new cell(s) with the combined data.

Use the Merge Values add-on

Another option is to use the Google Sheets add-on Merge Values. This extension lets you preserve your data when merging cells with an easy-to-use interface.

Keep in mind that Merge Values is a third-party add-on requiring access to your Google account for Google Sheets. You can view these permissions in the description for the extension.

Step 1: Once you install the add-on, head back to your sheet, select the cells you want to merge, and click Extensions > Merge Values > Start from the menu.

Use the Merge Values add-on in Google Sheets.
Image used with permission by copyright holder

Step 2: When the add-on’s sidebar displays, complete the details to merge the cells and retain the data.

Choose how to merge the selected values: Pick from in each selected row, in each selected column, or into one cell.

Separate values with: Select your separator from a space, semicolon, comma, or line break.

Place the results in the: Choose where you want your results from the left cell or right cell.

Options: Check the boxes for any additional options you want to apply such as skipping empty cells or wrapping text.

Merge Values add-on in Google Sheets.
Image used with permission by copyright holder

Step 3: Click Merge when you’re ready and you’ll have your data combined and cells merged.

Be aware that the Merge Values add-on is free for a trial period and then requires a paid subscription.

Merged values using an add-on in Google Sheets.
Image used with permission by copyright holder

Unmerge cells in Google Sheets

If you merge a set of cells in Google Sheets and decide later you want them in separate cells again, you can unmerge them. Keep in mind that you can only unmerge cells that you’ve merged.

Select the cell you want to unmerge. Click the Merge Cells drop-down arrow in the toolbar or Format > Merge cells from the menu and pick Unmerge.

Merging cells in Google Sheets is a convenient feature and especially useful for column and row headers. Hopefully one of the options listed here for retaining your data if needed works for you!

For using additional features, take a look at how to make a graph or chart in Google Sheets.

Sandy Writtenhouse
Sandy has been writing about technology since 2012. Her work has appeared on How-To Geek, Lifewire, MakeUseOf, iDownloadBlog…
Google Sheets vs. Microsoft Excel: Which is better?
Microsoft's PowerPoint on the Vision Pro.

Workplace visualization tools make the world go round, and will definitely liven up your before-lunch presentation. If you’ve got hard numbers to display to the masses, or graph-scribed projections you’re eager to get onscreen, you’ll need a powerful spreadsheet. You can use Google Sheets, or you can use Microsoft Excel -- they're both great ways to get the job done. But which of these two platforms is truly the best option? That depends on a number of things, and we’re not here to dissuade or encourage, but merely to inform.

We actually love Google Sheets and Excel, but for different reasons. One software may not be ideal for A, B, and C, although it may be really good at D, E, and F. Whatever the case may be, we put together this comparison of Google Sheets and Excel, with focus paid to essential categories like application access, data analysis, and charts and graphs. 
The basics
It’s worth stating from the start that both Sheets and Excel are excellent spreadsheet applications. So if you have the opportunity to try them both out, you may have a clear preference from the start. But if you’re doing your research first, just know that you can’t go wrong with either.

Read more
How to convert Excel files to Google Sheets
A MacBook on a table using Google Sheets.

If you use Google Sheets, then you'll know that it is a versatile tool that can pick up and run with any existing spreadsheets from applications like Microsoft Excel. You can even convert existing Excel spreadsheets to Google Sheet documents. Whether you're looking to using Microsoft Excel or want the improved ease of collaboration and sharing that Sheets offers for that particular spreadsheet, here's how to convert Excel files to Google Sheets in just a few steps.

Read more
How to use VLOOKUP in Excel
An Excel employee database.

As you use Microsoft Excel more and more, you'll find that the VLOOKUP function is a very popular tool for dealing with large Excel directories or databases. It allows the user to quickly find targeted information about a specific entry without needing to look through the entire spreadsheet.

Read more