See all How-To Articles

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 initial data

 

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.

 

merge multiple cells initial data

 

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.

 

merge multiple cells 1

 

As a result, cells B2 and C2 are now merged into one cell (B2). The text is by default centered in the merged cell.

 

merge multiple cells final data

 

If you click on the cell next to the Merge & Center button, you could also merge across (left-aligns text) or unmerge cells.

 

merge cells options

 

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.

 

merge range of cells

 

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.

 

merge range of cells final

 

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.

 

google sheets merge cells

 

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.

 

google sheets merge cells final

 

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.

 

google sheets merge horizontally vertically

 

This way, you can merge cells in rows or columns, not only into a single cell.