LearnFast.Ninja

Merge cells without losing data in Excel 2010

How to merge cells in Excel 2010 without losing data. In this example we fill all the values to one cell then merge the selected cells into the one cell with the values.

Step 1: Expand the column to be with enough space for all text, this step is necessary. 


Step 2: 
Select the cells you want to merge.


Step 3: Click Home tab then click Fill then click Justify.


Step 4: Select again the cells. 


Step 5: Click Home tab then click Merge & Center arrow then click Merge Cells.


Result:


Tags

excel

merge cells