What is the difference between relative and absolute cell referenc

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Hi,

I am am new user and am need of some assistance in regards to the above.
Sometimes in cell formulas there are $ signs, and other times not. What is
the difference?

Any help would be greatly appreciated.
tx
 
Relative

=A1 is relative, if you drag the formula right the A will increment to =B2
etc and if you drag down the 1 becomes 2

=$A1 is column absolute so if you drag right the column stays the same but
if you drag down +A1 becomes =A2

=$a$1 is absolute and dragging in either direction will not increase the
column or row.

Mike
 
Help explains quite nicely what the $ signs mean and when to use them.

Type "cell references" into the Help box.


Gord Dibben MS Excel MVP
 
Back
Top