how to add multiple rows in excel between data

Now, we need the total of these numbers in cell G1. Example #2 – Sum Multiple Rows to Single Cell

You use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.

Select the cell you want to combine first. Now, press the “Enter” key to get the sum of numbers. Choose the cell you want to combine the data with. It has selected the complete range of cells. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1. Then, hold the “Shift + Ctrl” key and press the “down arrow” to select the last cell reference Cell Reference Cell reference in excel is referring the other cells to a cell to use its values or properties. We must first open the SUM function in the C3 cell. The second method is best suited for 99% of the cases. In the second method, we can choose the range of cells with an excel shortcut key Excel Shortcut Key An Excel shortcut is a technique of performing a manual task in a quicker way. The first method is not the most popular because we must select the cells individually.

How to add multiple rows in excel between data