In this post, you will learn all about merging cells in Google Sheets. You will know what it means to merge cells and when it’s appropriate to do so, as well as learn the different options available. Additionally, you have step-by-step instructions on how to merge and unmerge cells, how to find and unmerge cells in a spreadsheet, and how to combine or concatenate the contents of two or more cells without merging the cells themselves.
To learn more about concatenation in Google
Sheets, check out this post on How to Use CONCATENATE in Google Sheets (Complete Guide + Examples).
When to Merge Cells in Google Sheets?
When you merge two or more cells, they become a single cell with the dimensions of the original cells. Usually, users merge cells to provide visual structure to titles or headers. In other words, its use is related to aesthetics, not functionality. This makes it suitable for dashboards or report templates, but it’s best not to merge cells on sheets where you store, manipulate, or analyze data, particularly when collaborating with others.
It’s especially important to note that only the top-left contents will be kept when you merge, so you need to ensure that the other cells are empty or that you can afford to lose the contents. In a later section, you will learn how to combine the contents of the cells instead of merging them.
Let’s say you’re creating a table that summarizes quarterly sales for the last two years using the structure shown below.
How to Merge Cells in Google Sheets (Complete Guide) - Table Structure
Many use the merge option to make it more visually appealing.
How to Merge Cells in Google Sheets (Complete Guide) - Merged Header
In the next section, you will learn how to merge cells using the three options available.
How to Merge Cells in Google Sheets?
To merge cells in Google Sheets, first select the cells you want to merge.
How to Merge Cells in Google Sheets (Complete Guide) - Select Cells to Merge
Once the cells are selected, go to Format > Merge cells.
How to Merge Cells in Google Sheets (Complete Guide) - Format Merge Cells
As you can see, there are three different ways to merge. Let’s see how each one works.
Merge All
If you want to merge your selection of cells into one giant cell, select ‘Merge all”.
How to Merge Cells in Google Sheets (Complete Guide) - Select Merge All
You can see that you now have just one cell, but its dimensions are those of the range of cells: ‘A1:C7’.
How to Merge Cells in Google Sheets (Complete Guide) - Merged All Cells
Merge Vertically
When you merge cells vertically, you merge the rows within each column of your selection. Let’s see what happens if you choose to “Merge vertically” on the same selection of cells as before.
How to Merge Cells in Google Sheets (Complete Guide) - Merge Vertically
You now have one merged cell per column, and the height of the merged cell equals the number of rows in your original selection.
How to Merge Cells in Google Sheets (Complete Guide) - Vertically Merged Cells
Merge Horizontally
In some cases, you may want to merge cells horizontally so that the columns in your selection are merged per row. Let’s see what happens when you choose “Merge horizontally”.
How to Merge Cells in Google Sheets (Complete Guide) - Merge Horizontally
You now have seven merged cells, each three columns wide.
How to Merge Cells in Google Sheets (Complete Guide) - Horizontally Merged Cells
How to Unmerge Cells in Google Sheets?
To unmerge cells, first, select the merged cells.
How to Merge Cells in Google Sheets (Complete Guide) - Select Cells to Unmerge
Go to Format > Merge cells or access the Merge options from the toolbar.
How to Merge Cells in Google Sheets (Complete Guide) - Select Unmerge Cells
After you click “Unmerge”, the contents of the merged cells go back to the top-left cell.
How to Merge Cells in Google Sheets (Complete Guide) - Unmerged Cells
What is the Shortcut for Merging Cells in Google Sheets?
Unfortunately, there is no native shortcut for merging cells in Google Sheets. However, you can easily access the merge options button on the toolbar.
How to Merge Cells in Google Sheets (Complete Guide) - Toolbar Access
How to Find Merged Cells in Google Sheets?
Google Sheets doesn't have a built-in function for finding merged cells, so it isn’t always easy to track them down. If it’s a small spreadsheet, they should be easy to spot through visual inspection, as merged cells will be wider or taller than normal cells. However, if it’s a large spreadsheet, this can be very time-consuming.
Usually, if you’re looking for merged cells, it’s because you want to remove them to avoid unexpected problems when you analyze or manipulate the data. If you’re not interested in keeping any existing formats, you can clear the formatting for each sheet or tab, which will also unmerge any merged cells.
Go to the sheet or tab where you want to remove merged cells. Click on the top-left corner to select all cells, as shown below.
How to Merge Cells in Google Sheets (Complete Guide) - Select All Cells in Sheet
Go to Format > Clear formatting.
How to Merge Cells in Google Sheets (Complete Guide) - Clear Formatting
As you can see, the cells have been unmerged.
How to Merge Cells in Google Sheets (Complete Guide) - Unmerged Cells
How to Combine the Text of Cells in Google Sheets?
To combine the contents of different cells without merging them, you can use the CONCATENATE function, the “&” operator, or the JOIN function.
For example, say you have a list of first names and last names, and you want to combine them to get the full name in one cell.
How to Merge Cells in Google Sheets (Complete Guide) - Table with Names
Merging won’t work, as you’ll only keep the top-left data - in this case, the first name.
How to Merge Cells in Google Sheets (Complete Guide) - Lost Data Warning
Combine Text Using CONCATENATE
In an empty cell, type the equal sign, followed by the CONCATENATE function.
How to Merge Cells in Google Sheets (Complete Guide) - CONCATENATE Formula
Select the cells with the contents you want to combine.
How to Merge Cells in Google Sheets (Complete Guide) - Select Cells to Combine
As you can see, the contents have been combined but without any delimiters.
How to Merge Cells in Google Sheets (Complete Guide) - Concatenated Contents
If you want to include a space or a symbol between the contents of each cell, you should use the “&” operator or the JOIN function.
How to Use CONCATENATE in Google Sheets?
You can easily combine content from different cells with the CONCATENATE function. Here's how to use CONCATENATE in Google Sheets.
READ MORE
Combine Text Using “&”
To combine the text from two cells using the “&” operator, type the equal sign and select the first cell you want to combine.
How to Merge Cells in Google Sheets (Complete Guide) - Select First Cell
Add the “&”, then add the delimiter you want to use between quotation marks.
How to Merge Cells in Google Sheets (Complete Guide) - Use “&” Operator
Finally, add another “&” and the second cell, then press ‘Enter’.
How to Merge Cells in Google Sheets (Complete Guide) - Select Second Cell
You can then grab the fill handle and drag it down to copy the formula.
How to Merge Cells in Google Sheets (Complete Guide) - Copy Formula
Combine Text Using JOIN
The JOIN function allows you to specify a delimiter in addition to combining the text from the cells.
Type the equal sign, then the JOIN function.
How to Merge Cells in Google Sheets (Complete Guide) - JOIN Function
Add your chosen delimiter between quotation marks, then a comma.
How to Merge Cells in Google Sheets (Complete Guide) - Add Delimiter
Finally, add the cells with the contents you want to combine and press ‘Enter’.
How to Merge Cells in Google Sheets (Complete Guide) - Select Cells
As you can see, the combined contents are separated by a space. Grab the fill handle and drag it down to copy the formula.
How to Merge Cells in Google Sheets (Complete Guide) - JOIN Result
How to Merge Cells in Google Sheets Without Losing Data?
Layer is an add-on that equips you with the tools to increase efficiency and data quality in your processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds. See how it works.
Using Layer, you can:
- Share & Collaborate: Automate your data collection and validation through user controls.
- Automate & Schedule: Schedule recurring data collection and distribution tasks.
- Integrate & Sync: Connect to your tech stack and sync all your data in one place.
- Visualize & Report: Generate and share reports with real-time data and actionable decisions.
Limited Time Offer: Install the Layer Google Sheets Add-On today and Get Free Access to all the paid features, so you can start managing, automating, and scaling your processes on top of Google Sheets!
Conclusion
Merging cells in Google Sheets is easy. You can merge all cells into one, or you can merge them vertically or horizontally to merge the rows per column or vice versa. Unfortunately, Google Sheets has no native keyboard shortcut for merging cells and no native function to find them within spreadsheets. However, the toolbar button is easily accessible and provides all the options.
If you want to find the merged cells to remove them and don’t care about keeping the format, you now know how to unmerge all merged cells within a sheet or tab. Finally, you know how to combine the contents of multiple cells without merging the cells by using the CONCATENATE function, the “&” operator, and the JOIN function.