46,288 views
31 votes
31 votes
What is the difference between relative and absolute reference in ms excel?

User Mats Rietdijk
by
2.8k points

1 Answer

24 votes
24 votes

Answer:

Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

User Rosalina
by
2.8k points