#Merging cells in excel 2016 how to

Now it will give the sorted values of First Name.

I sorted the First Name column.įrom Data Tab click on Sort then a dialogue box will pop up. Merging Multiple Rows with Same Values Using VBAįirst, sort the rows based on which you want to apply VBA. Now it’s showing the merged values of the same rows.Ĥ. Now select the E4 cell and double click on the right corner to copy the formula for the rest of the cells. Here the first value didn’t find the same value. It will start comparing consecutive values. I sorted the First Name column using Sort A to Z.Īfter typing the formula in Formula Bar press Enter. After sorting select the cell where you want to keep the same values then press (=) type the IF function. Using the IF function, you can merge the same values in Excel.įirst, go to the Data tab then click on Sort to sort the table based on which you want to merge rows with the same values.

Read more: Merge Duplicate Rows in Excel 3. Here are the Merged same values with the SUM of Product Price. Mark on the Left column as I am Merging the First name values and summing Product Price. Then take the Reference of the multiple cells you want to consolidate. I selected t wo columns.įirst, open the Data tab then selects Consolidate.Īfter selecting Consolidate a dialogue box will pop up from where you can select the functions given. Consolidate also allows doing some operations using functions within the same values.īefore applying Consolidate to put the merged rows select the cells where you want to keep merged rows with the same value. To merge multiple rows with the same values you can use Consolidate. Then click on OK.Īfter clicking on OK It will merge the rows with the same value. From these options select Merge Cells.Īfter selecting Merge Cells it will pop up a message which values it is going to keep. Merging Rows using Merge Cellsįirst, select the rows you want to merge then open the Home tab and expand Merge & Centre.

#Merging cells in excel 2016 how to

Read more: How to Merge Rows and Columns in Excel II. Now click on OK.Īfter clicking OK you will get the merged rows where the value is in the Centre. Where it says it keeps the upper-left value. Then open the Home tab then expand Merge & Centre option and select Merge & Centre.Īfter selecting Merge & Centre a dialogue box will pop up with a message. First, select the rows with the same value you want to merge. You can merge rows using the Merge & Centre option from Ribbon. Ways to Merge Rows with Same Value in Excel 1.