How to Merge Multiple Cells in Excel & Google Sheets
In this tutorial, you will learn how to merge cells in Excel and Google Sheets.
Merge Multiple Cells
In Excel, you often need to merge two or more cells in order to fit the text from one of those cells without expanding its width. Say cell B2 has the text “Product name,” which is too long to fit the cell.
To fit the text from B2, merge two cells (B2 and C2). Select the cells you want to merge and in the Ribbon, go to Home > Merge & Center.
As a result, cells B2 and C2 are now merged into one cell (B2). The text is by default centered in the merged cell.
If you click on the cell next to the Merge & Center button, you could also merge across (left-aligns text) or unmerge cells.
Apart from the Ribbon options, you can also use a shortcut to merge multiple cells.
Note: Merge cell option will always keep the value from the most left cell in the range that you want to merge, while values from the other cells will be deleted. Say you want to merge range B2:C3 into one cell.
If you repeat the steps above and merge these four cells into one, you will see that only “Product name” from cell B2 is now in the merged cell.
You can also use VBA code to merge cells in Excel.
Merge Multiple Cells in Google Sheets
Merging cells work almost similarly to Excel. If you use the same example as in Excel, you need to select cells B2 and C2, and in the menu click on the Merge cells icon.
The result is the same as in Excel. Cells B2 and C2 are merged into one cell, keeping the text from B2. When you select the merged cell, you can see that the Merge cells icon in the menu is highlighted in green, indicating that the cell is merged.
Unlike Excel, Google Sheets has the option to choose between merging horizontally or vertically in case of merging a range of cells. If you select a range of cells to merge, you will see these options if you click on the arrow next to the Merge cells icon.
This way, you can merge cells in rows or columns, not only into a single cell.