How To Combine Two Cells In Google Sheets

In this tutorial, you will learn how to combine two cells in Google Sheets.

How To Combine Two Cells In Google Sheets

There are many different reasons why you might want to combine or merge cells in Google Sheets.

For example, you might have column headers that apply to multiple columns or data, or you might want to combine cells to get finer control of the layout of your spreadsheet.

Whatever your reasons for wanting to combine cells, it’s easy to do in Google Sheets. Read on to learn how.

Merging Cells

You can merge any number of adjacent cells in Google Sheets. Once merged, the cells will act as a single cell

 

Here’s how to merge cells:

Step 1

Select the sells you want to merge. Note that merging cells will only preserve the top-leftmost value in the merged range

Step 2

Click on the down arrow beside the Merge Cells icon in the toolbar and select the Merge All option to merge all selected cells

Step 3

If you want to merge only rows or only columns in the range, select the Merge Horizontally or Merge Vertically options

Step 4

If you want to reference data in a merged cell, use the cell reference for the top-leftmost cell in the range.

For example, if you’re trying to access data in a merged cell that spans the range D2:F2, use the cell reference for D2

Unmerging Cells

If you ever need to unmerge cells in Google Sheets, just follow these steps:

Step 1

Select the merged cell or cells you want to unmerge

Step 2

Click on the down arrow beside the Merge Cells icon in the toolbar and select the Unmerge option at the bottom of the menu

Step 3

All cells in the selected ranges will be unmerged

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to combine two cells in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.