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

asked
User Pep
by
8.5k 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.

answered
User Ansal Ali
by
8.5k points

No related questions found