Entering Absolute Cell Location In A Formula

[Alton B. Wilson]

Hello All,

When I enter cell addresses into a formula, I can simply click on a cell, to
have that cell's relative location added into a formula ( = C1 + D2). I
want to click on the cells and have the absolute location added into a
formula (=$C1 + $D1). Is there a combination of <CTRL> or <SHIFT> etc. that
will do this?

Thanks a lot in advance.

Regards,

Alton

 

[Peo Sjoblom]

= click C1, press F4, + click D2, press F4

 

[Alton B. Wilson]

Thank you very much Peo. Much appreciated.

Alton