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

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.

User Ansal Ali
by
8.5k points

No related questions found

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.