$B$15 vs $B15

D

dlw

when you copy $B$15 to other cells, it will always be B15, when you copy
$B15, the 15 with change relative to the cells you copy it to.
 
E

Elkar

I posted a response to your previous post. Was it not clear?

Perhaps looking up "absolute and relative references" in the Excel Help will
offer a better description.

HTH,
Elkar
 
A

Alan

It's Absolute or Relative referencing. It sounds complicated but its not.
Using the dollar signs keeps the reference to the cell constant when you
drag a formula down or across, not using the dollar signs doesn't. You can
Absolute the column, the row, both or none depending on what you want to do.
=$A$1 will stay as =A1 if you drag the formula down or across in another
column.
Without the dollar signs dragging down =A1 will change to =B1, =C1 etc,
dragging across will change to =B1, =C1 etc.
This is an essential part of any spreadsheet, without it one would be typing
forever when dragging formulas.
Check out 'Absolute Reference' in Help, It's all there,
Regards,
Alan.
Regards,
Alan.
 
A

Alan

Without the dollar signs dragging down =A1 will change to =B1, =C1 etc,
dragging across will change to =B1, =C1 etc.

Thats =A1, A2, A3 etc, my mistake,
Alan.
 
Top