RELATIVE REFERENCING AND ABSOLUTE REFERENCING IN EXCEL

RELATIVE REFERENCING:

          When a formula is copied from one cell to another in excel the value of the cell changes relative to the starting value this is relative referencing

ABSOLUTE REFERENCING:

               There may be times when you do not want a cell reference to change when filling cells. Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant.

APPLYING ABSOLUTE AND RELATIVE REFERENCING:

            

      An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.

            When writing a formula, you can press the F4 key on your keyboard to switch between relative and absolute cell references. This is an easy way to quickly insert an absolute reference.

EG.:

$A2 =COLUMN DOESNOT CHANGE WHEN COPIED

$A$2=COLUMN AND ROW DOESNOT CHANGE WHEN COPIED

A$2= ROW DOESNOT CHANGE WHEN COPIED

RELATIVE REFERENCING VS ABSOLUTE REFERNCING:

RELATIVE REFERENCING:

Here when formula is dragged c3 becomes c4 and a3 become a4 so the value of b4 also change

ABSOLUTE REFERENCING:

Here since absolute referencing is being used with c3 its value doesnot change value of a3 changes when it is draged