Saturday, April 23, 2022

Relative Referencing and Absolute Referencing Explained

 

There are two main types of cell references in Microsoft Excel namely relative and absolute although there is another reference TYPE called mixed reference where part of the reference is Relative and part is absolute. The two main types of reference behave differently when copied and filled DOWN to other cells.

Relative references change when a formula is copied to another cell. While Absolute references, on the other hand, remain constant no matter where they are copied. In order to understand how the two reference types are used, go to the tutorial in the link below

RELATIVE AND ADSOLUTE REFERENCE VIDEO TUTORIAL

No comments:

Post a Comment

Why Give?

  ic Give not because you have enough, not even because you expect a payback some day, and not even because you want to be celebrated by tho...