IDNLearn.com provides a user-friendly platform for finding and sharing knowledge. Ask your questions and receive comprehensive, trustworthy responses from our dedicated team of experts.

what is the difference between relative and absolute reference in ms excel?


Sagot :

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.