how to






 

Question by  caluwi (199)

How do I merge rows in excel?

 
+7

Answer by  pinki (39)

We can join the rows in the excel by right clicking the mouse then select format cell and then select alingment and from the alingment select wrap the text and then click ok dialogue box. After doinig this steps the rows get merged up in the excel sheeet.

 
+7

Answer by  bleo (41)

This depends highly how you are merging your rows. If you have more specific needs you can purchase an Excell add-on call Merge Cells Wizars. Otherwise, you can used the CONCATENATE() function to merge specific cells from these columns to make a new cell with your newly merged data.

 
+7

Answer by  pdash (63)

Select the rows, right click on selected rows, select 'Format Cells', click on 'Alignment' tab, under 'Text Control' section choose 'Merge Cell'.

 
+6

Answer by  tbk (257)

Highlight or select a range of cells then right click on the highlighted cells and select Format Cells. Click alignment tab and place a check-mark in check-box labeled Merge cells.

 
+6

Answer by  pollypink (36)

Using the left mouse button, click and hold on the first row to be merged. Drag the mouse to select the rows you want and release the button. Right click and select the "Format cells" menu and the "Alignment" tab; check the box in front of "Merge Cells".

 
+5

Answer by  guyzer450 (188)

Right click on the cells you wish to merge, and then in the drop down box there should be a selection saying format cells, go to that, and then select merge cells.

 
+4

Answer by  wasimay16 (23)

We can join the rows in the excel by right clicking the mouse then select format cell and then select alignment and from the alignment select wrap the text and then click ok dialogue box.After doing this steps the rows get merged in the excel sheet this process you can do merge rows in excel.

 
+4

Answer by  Lisa22 (100)

You need to highlight the rows you would like to merge. Then look up at your toolbar and click on the icon with an A. This joins the rose hightlighted.

 
+4

Answer by  mcr666 (362)

There is an option in the cell group on excel that allows you to merge the cells. Slect the cells you want merged and click merge.

 
+3

Answer by  murali680 (559)

The followings are the steps to merge the row. Select the row you want to merge in table- right click mouse-click format cells-click alignment tap-click merge cells option-press ok.

 
You have 50 words left!