Having problems with static positioning

D

DCLBaker

Hi, Does anyone know who to resolve this problem? Every time I do a
formula it automatically adds a $ to the column and row reference so that
the formula looks like this: =sum$H$7. I am having to use the “replace†to
remove the $. Somehow I turned on this method and I can’t figure out how
to turn it off.

Anyone got a suggestion?
 
D

Dave Peterson

If you're building the formula using the mouse and you're pointing at a
different workbook, you'll see those absolute reference $. That's the way excel
works.

But if you're typing the formula manually, I've never seen excel do this.

But you can cycle through the absolute references by selecting the formula in
the formulabar (or just a portion of the formula) and hitting F4.

$h$7
$h7
h$7
h7

(maybe not in that order, though.)
 
Top