Excel: Use relative reference - how it works
If you want to perform the same arithmetic operation with different fields in Excel, the "Relative reference" feature is useful. This practical tip shows you how to use the function.
Excel: Use relative reference - how it works
The relative relationship in Excel can be used very well if you want to use a certain formula with several values.
- First, compile a list in Excel with all the values you need. You can find a simple example of this in the screenshot on the right.
- Then enter your formula and check that it is correct. Errors can quickly arise, especially with longer calculations.
- Now mark the field in which the formula is located. Take it with the cursor at the bottom right corner and then drag it to where you still need the result.
- Excel will automatically adjust the fields in the calculation to the current line. If you always want to leave a field of the formula the same, mark the corresponding position in the formula and press [F4]. The program thus knows that the relative reference should not apply to this field.
In the next practical tip, you will learn how to add or subtract numbers in Excel.