In this article we will show you exactly how to merge cells in Google Sheets. Just follow the simple steps below:
For the purposes of this demonstration a sample sheet was created. Click here to access the sample sheet and follow along at home.
While there is no allocated keyboard shortcut to Merge cells in Google Sheets, we can achieve this task by using the toolbar method.
Left Click on one of the cells you want to merge then hold down the left mouse key and drag across to the next cell highlighting them both.
For vertical selections, repeat this step but drag the cursor downwards.
On the toolbar there is a ‘Merge Cells’ option, click this to begin the process.
While the Merge Cells tool operates intuitively based on what has been selected, there is a dropdown menu available via an arrow just to the right of the Merge icon that will give you the option to select a horizontal or vertical cell merger.
By merging cells, the information that is in the top-leftmost cell will be all that is retained by the spreadsheet. The data in the cell(s) to the right will be lost.
You will receive the following warning when clicking the Merge Cell function. Make sure that all information you wish to retain is backed up before clicking ’OK’ on this message.
If you would like to merge cells without data loss, then check out our other article about how to merge cells and keep data in Google Sheets.
The cells have now been merged and only contain the information from the top-leftmost cell, this will also happen with vertical selections.
In this article we demonstrated the application of how to merge cells in Google Sheets.
-Split Text to Rows in Google Sheets
-Split Text to Columns in Google Sheets
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
