204k views
3 votes
What is the difference between relative and absolute reference in ms excel?

User Pep
by
5.0k points

1 Answer

8 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 Ansal Ali
by
5.6k points