a quick question

[zendog1960]

I have alot of absolute values I need to put in. Is the a key stroke that will make the cell I select have $ in front of the cell? For example I am putting in a formula like:

=A1+C4 when I select C4 I would like it to automatically put in $C$4.

Is there a keystroke for that?

 

[Norie]

F4 will cycle through absolute/relative references.

 

[Domski]

Hi,

Use F4 as you enter the cell reference.

Press it more than once to cycle through total, column and row absolute.

 

[zendog1960]

Thanks Guys