Now, press the “Enter” key to get the sum of numbers.
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.
0 kommentar(er)
