Relative and Absolute Cell References
Relative Reference When copied across multiple cells, they change based on the relative position of rows and columns. To create and copy a formula using relative references: In the following example, we want to create a formula that will multiply each item's price by the quantity . Select the Cell That we will contain the formula, well we select the Cell D2 2. Enter the Formula in Cell D2 to calculate the value. 3. Press the Enter to calculate the formula you entered 4. Locate the fill handle in the lower-right corner of the desired cell. 5. Click and hold the fill hundle from D2 down to D10 6. Release the mouse and the formula will be copied and the values will be calculate. ABSOLUTE CELL REFERENCE Select the cell will contain the formula Enter the Formula in Cell D2 to calculate the value