In this article:

How to Merge Cells in Google Sheets

Sometimes, you need to combine cells containing different information. You need to change multiple cells into one. You could also need to merge columns or rows and vertically or horizontally.

If you want to merge cells in Google Sheets, this is the tutorial for you. Here are 4 simple ways to do so depending on the data stored in the cell.

How to Merge Cells in Google Sheets (Method 1)

This first method uses the Google Sheets format menu to merge cells. This Google Sheets option is useful if you want to see all of the options for merging.

Step 1: Select the cells to merge.

Cells you want to merge selected

Step 2: Click Format in the main toolbar.

Step 3: Select Merge cells on the drop-down list.

Step 4:  Select Merge all. 

"Merge all" option with selected cells

Step 5: If the cells you merge have content, a box will appear, telling you that only the content of the upper leftmost cell will remain. Click OK. 

Cell merge warning

The cells are now merged:

Merged cells in Google Sheets

You can reference the screen recording below to make the steps to merge cells google sheets crystal-clear to you:

You can use these same steps to merge cells in the same column:

How to Merge Cells in Google Sheets (Method 2)

You can also merge cells in just a single click, and that is through the merge cells icon in the main toolbar. 

After selecting your cells, simply press this button in the main menu.

Merge cells button

You can check the screen recording below:

Merging Cells Animation

Additional options to merge cells Google Sheets

Merge cells vertically in Google Sheets

Google Sheets also allows you to merge cells of a selected range vertically or horizontally, thus creating long columns or long rows, respectively, instead of a single cell. Whereas the "Merge all" option creates only one big cell, these options create merged rows or columns even if you select multiple rows or columns.

To do so, here are the steps:

Step 1: Select the cells to merge.

Cells selected

Step 2: Click Format in the main toolbar, select Merge cells on the drop-down list, then select Merge vertically or Merge horizontally, depending on what you need.

"Merge vertically" option

Step 3: If the cells you merge have content, a box will appear, telling you that only the content of the upper leftmost box will remain. Click Ok. 

Merge Cells Warning

The cells are now merged:

Vertically merged cells

You can check the screen recording below to make the steps to make this method to merge cells crystal-clear to you:

Merge vertically animation

Merge Horizontally in Google Sheets

Merging cells horizontally will merge each cell in a row into one cell. Even if you select more than rows, it will only merge across an individual row.

The steps to merge horizontally are just as easy. Just follow the same steps to merge vertically and choose the option to "merge horizontally."

Merge horizontally animation

Keyboard shortcut to merge cells Google Sheets (Method 4)

Check out our article about a simple merge cells shortcut in Google Sheets.

You can merge cells through the following keyboard shortcuts:

Alt+O then Alt+M

This will open the merge options in the Format menu in Google Sheets. You can then select the option you want to apply:

Merge cells shortcut Google Sheets

How to Unmerge cells in Google Sheets

Check out our complete unmerge cells in Google Sheets tutorial.

Sometimes you need to revert merged cells to their previous form. Similarly to merging cells, this process is just as simple! Follow the steps below:

Step 1: Select the merged cell or cells to unmerge in Google Sheets. 

Merged cells

Step 2: Click in the main toolbar 

Step 3: Select Merge cells on the drop-down list

Step 4: Select Unmerge. 

Unmerge option in Google Sheets

Your merged cells are now unmerged:

Unmerged cells

You can also reference the screen recording below:

Unmerge cells in Google Sheets Animation

How to merge cells in Google Sheets without losing data

Unfortunately, the methods for merging cells in Google Sheets only preserve the upper left-most value. It removes the data that is not from the upper-leftmost cell of the range of cells you want to merge. Luckily, there is a solution in Google Sheets if you want to merge cell contents rather than the cells themselves:

-Merge Cells and Keep Data in Google Sheets

You can also use functions designed to combine strings of text to merge cells without losing data such as CONCAT, JOIN, and COMBINE.

Additionally, you can do so much more using these commands. You can check our other relevant tutorials below:

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started