Stupid Question...

  • Thread starter Thread starter DangerMouse114
  • Start date Start date
D

DangerMouse114

Hey Sorry guys this is dumb and something I learned in my most basi
excel class but can someone remind me how you go about getting one Cel
Id (i.e. AB12) to stay the same when you drag the formula accros
multiple cells?

I need almost a whole row to refrence ONE cell and it would be easie
if i could remember how to keep the refrence cell constant when I dra
the formula accross the whole row.

THANKS!

Eri
 
Use an absolute reference or a combination of absolute and relative
references ($A$1, $A1, A$1). You can cycle through the various combinations
by highlighting the cell reference in the formula bar and then hitting the
F4 key.
 
Back
Top