Hi friends, are you in search of useful tricks on how to merge cells in google sheets?
If yes, then your search comes to an ultimate end.
I bet with the below tricks your doubts related to merge cells in google sheets will be clear. But before disclosing these tricks let’s have an understanding of what is merge cells in Google sheets.
What Is Google Sheets Merge Cells?
Merge cells in G Sheets is an option that you can use to combine two or more cells to create a larger cell.
This feature is mostly used to create a header in tables or to organize data in multiple categories.
Below is the demonstration of normal cells and merged cells in Google sheets.
Here is a table that lists players of a football team.
Here, the heading “football team” can be written in a more understandable format with the help of the cell merge technique. Let’s have a look at how.
Have you noticed the difference?
We have merged the cells to create the header for the football team.
This is a very basic example of merge cell google sheets.
Let’s explore how to do it and what are 10 amazing ways on how to merge cells in google sheets.
How To Merge Cells In Google Sheets On A Desktop
- In a web browser, open Google Sheets.
- Select two or more than two cells that you want to merge.
- In the menu bar, click.
- Click MERGE in the drop-down menu.
Merge Cells In Google Sheets On A Phone
Do you know you can also merge cells while editing a spreadsheet in a mobile phone application from your android phone or iPhone. Follow the below steps.
- Open the Google sheets app on your phone.
- Now open a new spreadsheet.
- Tap and select two or more cells that you want to merge.
- When you select two or more cells a merge button will automatically appear at the bottom of your mobile screen. This will automatically merge selected cells.
Google Sheets – Merge All
With Merge All option you can merge an entire bunch of cells (regardless of their direction). Below are the steps you need to follow.
- Highlight the cells which you want to merge.
- Click format, and then in drop-down list select merge cells. After that, you need to select the “Merge All” option.
Google Sheets – Merge Horizontally
Do you want to select cells in a row and combine them. Here the output will be a long horizontal cell where selected cells in each column are merged. Below are steps to follow for how to merge cells in Google sheets – horizontal merge.
- First, highlight the horizontal cells.
- Click on the format and in the drop-down list select merge and your selected cells will be merged automatically.
- Similarly, on phone, you need to select horizontal cells and then click on merge on the bottom bar.
Google Sheets – Merge Vertically
Same as the previous one, the vertical merge option will allow you to select cells in a column and then merge them. The outcome will be a single long vertical column. Here are steps for how to merge cells in Google Sheets – Vertical Merge.
- Select the column cells that need to be merged.
- Now click on format and select merge as done in the previous option.
- If you are on your mobile phone, after selecting the cells, click on merge on the bottom bar.
Keyboard Shortcuts To Merge Cells Google Sheets
Generally, there is no such shortcut to merge cells in Google sheets. Every time you merge cells, you need to
- Open format menu.
- Click on Merge
- And then select what type of merge you want i.e., Merge all, Merge Horizontally or Merge Vertically.
However, if you want to stick to your keyboard then you can follow the below keyboard controls.
On Windows, you need to enter
Alt + O, M, Enter
Alt + O – Opens the format menu
M – Selects “Merge Cells” option
Enter – Selects “Merge All” option
If you are on Mac then use the below keyboard shortcut
Ctrl + Option + O, M, Enter
Ctrl + Option + O – Opens the format menu
M – Selects “Merge Cells” option
Enter – Selects “Merge All” option
How To Merge Cells In Google Sheets Without Losing Data?
Do you know, the merge option in Google sheets will only preserve the left and top values in the set of selected cells. The remaining data was lost while merging cells.
Now, the question is how you can save your data while merging cells.
The solution to this problem is to combine all the cells in one. Here merging of cells is not the correct method.
You need to use a formula to save your data. Use CONCATENATE (…) function to combine cell values.
Below are the steps to do it.
- Suppose you have to merge the first name and last name columns into a single name column.
- To do that insert a new column and give it a title as “NAME”.
- Now to merge both the cells, you need to use the formula =CONCATENATE(C6,D6).
- You will get merge data for C6 and D6 in E6.
- To do the same in the rest of the cells, copy and extend the formula in the first cells to the rest of the columns which will combine the rest of the values.
After combining both the required cells, if you wish to delete data for the First name and Last name i.e., the source columns, the data in the “NAME” column will be deleted. This is because the “Name” column is made using the column’s First name and Last name.
To delete the First name and Last name columns, you need to copy the column “NAME”.
After that paste it into another column, make sure to use the “Paste Values Only” option.
Now you can delete the first name and last name columns and previous “NAME” column and we are left with a new “NAME” column.
Merge Cells In Equal Proportion
Till now you must have got an idea then how to merge cells in Google Sheets – vertically and horizontally. In Google sheets, you can only merge cells in this way i.e., in equal proportion.
So, you can merge cells when they are selected equally like below.
However, you cannot merge cells if they are selected in unequal proportions like below.
So, while merging cells, always keep in mind to select cells in equal proportion for merging.
How To Merge Cells In Google Sheets App?
In the Google sheets mobile application also, you can merge cells. However, there you will get only merge all options. Here is how to merge cells in Google Sheets in a mobile phone.
- First, open the Google sheets application on your mobile phone.
- Open the required sheet where you have to merge data.
- Tap on the cell.
- Now drag the blue border to the cells which need to be merged.
- Click on the format icon.
- Then select “CELLS”
- Scroll down and enable the MERGE option to merge all the selected cells.
Tip – You can also merge selected cells in Google sheets by tapping on “Merge Icon” in the Google sheets application.
How To Merge Names In Google Sheets
Suppose you have a data set where you have a list of first names and last names that you wish to merge in a single cell.
With the help of a simple formula, you can easily merge first names and last names in one cell. Here is how you can do this. Here are the steps.
- First, open the Google Sheet where first names and last names are given.
- Select the cell where the result for “Full Name” is to be displayed.
- In this selected cell using formula
=[First Name cell]&””&[Last Name cell]
- Now, as soon as you will press ENTER your first name and last name will combine and will give FULL NAME.
- Now, select the same cell and drag the formula to the border of your data set to apply it for all.
Important Points To Remember While Merging Cells In Google Sheets
I have prepared a list of important points which you should keep in mind while Merge cells in Google sheets.
- If you already have data in the google sheets cells which you are merging then data in sheet cells which are on the top and left most side will take precedence in the final result of merged cells. Here data in the remaining sheets will be lost. But not to worry as in the above article I have already mentioned how you can merge cells without losing data. Also, if you have clicked on the merge option accidentally then Google sheets will display a warning message and you can cancel the merge action.
- It is better to avoid storing data in merged cells. As merged cells will normally break the cardinal rule of each data piece existing in its cell.
- Merge cells can create issues in applying any formula, creating pivot tables, and moving data to another location.
- Sort function cannot be used on the columns which already have merged cells in them. If you are trying to do it. It will display an error message.
- If you have some data in merged cells and you only want the content of the merged cells to be copied to a new location, then you will not be able to do it directly. As merge cells will also be copied. So, to avoid copying of merge cells to the new location you need to use the special paste format i.e., paste data as value only.
- Last but not the least, merge cells with google sheets is a very easy process, however, this should be used with caution. If merge cell is used incorrectly then this may result in trouble. So, to be on the safe side, always use merge cells in google sheets for formatting purposes only.
To better organize your data in Google sheets “merge cells” is a very useful option. It will help you to easily understand the data.
In the above article, I have already shown, how easy it is to apply it in your Google sheets. And it also comes with various useful options like merge all, merges vertically, and merges horizontally.
Hope now your doubts related to how to merge cells in google sheets are clear. However, if you are still confused somewhere then do let me know in the comment section. And if you are curious to know about Google Sheets Pivot Table then click here.