Switch between relative and absolute references

When you create a formula that refers to another cell or range, that cellereference can be relative or absolute. A relative cell reference adjusts to its new location when the formula is copied or moved. An absolute cell reference does not change when the formula is moved.

  1. Select the cell that contains the cell reference that you want to change.

  2. In the formellinje, click the cell reference that you want to change.

  3. Press KOMMANDO + T to move through the combinations.

    In the following table, the Changes to column reflects how a reference type updates if a formula that contains the reference is copied two cells down and two cells to the right.

    Formel, der kopieres

Current reference (description):

Changes to:

$A$1 (absolut cellereference column and absolute row)

$A$1

A$1 (relativ cellereference column and absolute row)

C$1

$A1 (absolute column and relative row)

$A3

A1 (relative column and relative row)

C3

See also

Calculation operators and order of operations

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×