In some cases, you would have a need to merge some cells and combine these together to make one single cell. These could be either merging cells in rows or columns (or both).
One practical example of this is when you have a header that has is the same for multiple columns and you need to merge the cells to make the header look like one (as shown below).
In this tutorial, I will show you how to merge cells in Google Sheets (horizontally as well as vertically).
I will also cover some additional things you need to take care of when using Google Sheets to merge cells.
- On your computer, open a spreadsheet in Google Sheets.
- Select the rows, columns, or cells to merge.
- At the top, click Format. Merge cells, then select how you want your cells to be merged.
Combine Cell Contents from Two Different Columns in Google Sheets
Types of merging options in Google Sheets
Google Sheets offers the following merge options:
When to merge cells in Google Sheets
Merging cells in Google Sheets is helpful when creating a title above multiple columns or when you have a main title above subtitles. For instance, if your spreadsheet documents your organizations revenue over the past 10 years, you may create a main title labeled “Revenue” and subtitles for each year. Combining cells in Google Sheets is a beneficial method for keeping information organized and easy to understand, which can be especially important when sharing your spreadsheet with others. It also helps avoid clutter in your spreadsheet when creating long titles.
How to merge cells in Google Sheets on a desktop device
Consider following these steps to help you when merging cells in Google Sheets on a desktop computer:
1. Open Google Sheets
To merge cells in Google Sheets on your desktop, first open the application on your computer. You can accomplish this by accessing your desired web browser, such as Google Chrome or Safari. Once there, type sheets.google.com to open a new spreadsheet or edit an existing one. You can also access Google Sheets by clicking the Google Apps button in the top-right corner of your screen and selecting the green icon labeled “Sheets.”
2. Select cells to merge
When attempting to merge cells, try to choose two or more cells that you want to merge on Google Sheets. These can be cells in the same column or row since Google Sheets allows you to combine cells vertically and horizontally. Tap on the cells you want to merge by picking a starting cell and dragging your cursor across up or down, depending on whether you want to merge cells vertically or horizontally, to highlight them.
3. Click “Format”
The next step is to view the top of your Google Sheets page, click the menu bar and press the “Format” option. You can find this between the “Insert” and “Data” options. The format button provides you with a drop-down menu of various options.
4. Press “Merge cells”
From the “Format” drop-down menu, the next step is to select the “Merge Cells” option. Depending on which cells you select, this offers you options to merge horizontally, merge vertically or merge all. You can then choose the correct option based on your needs. For instance, if you want to merge two columns so you can make a longer title, select the “Merge horizontally” option. You also can merge cells by using the merge toolbar button between “borders” and “alignment.”
4. Realign text
Since merging cells causes text to shift to the left, consider realigning it to place the text in the center of your row or column. To accomplish this, highlight the text in the merged cell and click on the horizontal icon in your toolbar. After clicking this, a menu appears with options for you to select. Click the “Center” icon to move your text to the center.
How to merge cells in Google Sheets on a mobile device
You can follow these steps to merge cells in Google Sheets on a mobile device:
1. Open the Google Sheets app
The first step to merging cells in Google Sheets on your mobile device is opening the app on your phone. If you dont have this app on your device yet, you can visit the app store to download it. You also can access Google Sheets by opening a web browser on your device.
2. Select cells to merge
After opening Google Sheets on your device, its important to choose the cells you want to merge on your spreadsheet. This might be two or more cells that you want to transform into a single column or row. Highlight these cells by pressing with your finger and dragging either across or down.
3. Click the “Merge” button
Next, view the toolbar at the bottom of your Google Sheet to locate the “Merge” button. This feature is between the centered lines and paint can icons. After pressing the “Merge” button, you have merged the selected cells.
Challenges you may experience when merging cells in Google Sheets
When merging cells in Google Sheets, you may encounter a few challenges when trying to perform other actions. For example, you cant sort columns with merged cells on Google Sheets. If you want to sort your columns, you can first unmerge your cells by selecting the merged cells, clicking the “Format” button, selecting the “Merge cell” option and clicking on the “Unmerge” button. This allows you to sort your columns again. Once you organize them how you want, consider merging the cells again.
Another problem that may occur when merging cells in Google Sheets is that the text from a merged cell becomes formatted as a merged cell. For example, if you copied a header titled “Years” spanned across 10 columns and pasted it into the row below, it would say “Years” and cover 10 columns. To avoid this occurring, copy the text only as a value by using the CTRL + SHIFT + C keys. Then paste it as a value using CTRL + SHIFT + V.
Please note that none of the companies mentioned in this article are affiliated with Indeed.
Why can I not merge cells in Google Sheets?
How do I merge two cells in Google Sheets with names?
In a separate column of your spreadsheet, enter =CONCATENATE( . Then, select an individual’s first name (e.g., John). This will enter the column and row cell reference for the first name into the formula. If the desired cell has been referenced in the formula, then enter ,” “, .
Is there a shortcut for merging cells in Google Sheets?
Step#1: Select the cells you want to merge. Step#2: Press Alt + O → M to open the Merge option menu. Step#3: Click on the Merge type you want to apply.