Entering Absolute Cell Location In A Formula

  • Thread starter Thread starter Alton B. Wilson
  • Start date Start date
A

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
 
Back
Top