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.
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:
Select the sells you want to merge. Note that merging cells will only preserve the top-leftmost value in the merged range
Click on the down arrow beside the Merge Cells icon in the toolbar and select the Merge All option to merge all selected cells
If you want to merge only rows or only columns in the range, select the Merge Horizontally or Merge Vertically options
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
If you ever need to unmerge cells in Google Sheets, just follow these steps:
Select the merged cell or cells you want to unmerge
Click on the down arrow beside the Merge Cells icon in the toolbar and select the Unmerge option at the bottom of the menu
All cells in the selected ranges will be unmerged
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.