Use fixed cell references

You can address these cells directly. In a calculation you can refer to a specific cell in the spreadsheet and use its content.

Procedure

  1. Open a spreadsheet.

  2. Enter the relevant formula, for example, SUM. Enter a dollar sign ($) in front of both the column and the row:

    Cell references 1

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

    The references in the formula have not changed:

    Cell references 2

    You can also enter the dollar sign only in front of the column or only in front of the row in order to save only the column or the row.

You have inserted fixed cell references. If you insert the calculation cell at another position, the calculation of the original area is retained.