How to Merge cells in Microsoft Excel?

Created with Sketch.

How to Merge cells in Microsoft Excel?

There are different methods we can merge cells in Excel.

One of the most used methods is utilizing the Merge & Center option in the Home tab.

How to Merge cells in Microsoft Excel

The issue with using Merge & Center is that it can combine the cells, but not the text within these cells. Let us say we have a data set, as shown below:

How to Merge cells in Microsoft Excel

If we select cell A1 and B1 and use the Merge & Center option, it will keep the text from the leftmost cell (A1 in this case) and delete the text from all other cells.

Excel is not utterly ruthless, though it warns you before this happens. If you try and merge cells that have text in it, it shows a warning pop-up letting you know of this (as shown below).

How to Merge cells in Microsoft Excel

If we go ahead and click OK, it will combine the two cells and keep the text from the leftmost cell only. In the above example, it will combine A1 and B1 and will show the Employee Name only.


 

Leave a Reply

Your email address will not be published. Required fields are marked *

This is a free online math calculator together with a variety of other free math calculatorsMaths calculators
+