What is the difference between relative and absolute cell referenc

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
 
M

Mike H

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to change referenced column to the next one 1
External cell reference between two excel worksheets both in One Drive 0
Referencing cells in consecutive rows 2
White space above heading inconsistently applied 1
Using <= in countifs statement 1
Referencing an External Cell 1
Using icon sets with relative references 0
Hide columns based on row values 2

Top