December 4, 2020

How to Merge cells in Excel

Please follow the below process to merge the cells in Excel.

Step 1 : In the below example we will be merging the cells A1, B1, C1, D1, A2, B2, C2 & D2.

Step 2 : Select all the cells you need to merge and click ‘Merge & Center’ available in Home tab of Excel Tool Bar.

Step 3 : This warning message you will get if multiple cells contain values. If all cells are blank or only left/upper left most cell has value then this message won’t appear.

Step 4 : Once you press OK in the above message, here is 4 cells merged into 1 cell containing the value of left/upper left most cell(A1) only.

If you don’t want to lose the values of other cells by getting merged, use the CONCATENATE Formula.

Note : When you use Merge & Center option to merge cells, it will no more allow you to sort that data set. If you try to sort a data set that has any merged cells, it will show you the following pop-up :

Leave a Reply

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