Select a cell and lock it...

S

Somecallmejosh

Hello,

In regards to formulas.... If I enter an "=" sign, as to
indicate the beginnings of a formula in one cell, is it
possible to select another cell and automatically anchor
that specific cell in the formula without having to type
the "$" in the forumla...

Example... I would like to select B12 as $B$12 and place
it in the formula without having to go back and type in
the "$" in the cell containing the formula. Is there a
key combination that will allow this, or I am stuck
having to type those "$"'s everytime?

Thanks in advance.

Josh
 
F

Frank Kabel

Hi
use F4 to toglle between absolute/relative references directly after
selecting the other cell
 
S

Somecallmejosh

Perfect.... Thank you very much.
-----Original Message-----
Hi
use F4 to toglle between absolute/relative references directly after
selecting the other cell

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag news:27b501c4c126$f6f7f5e0 [email protected]...

.
Click to expand...
 
Top