Use relative cell references

You can refer to another cell in the spreadsheet and use its content.

Procedure

  1. Open a spreadsheet.

  2. Enter the relevant formula, for example, SUM.

    Cell references 1

  3. Copy these cells and paste them at another position in the spreadsheet.

    The references in the formula have changed:

    Cell references 2

You have inserted relative cell references. If you insert the calculation cell at another position, the calculation is performed for the new area, as well.