by 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 :
