Absolute cell reference

M

Madhu Ramamurthy

Hi ,

Can you please tell me the keyboard shortcut to inserting absolute cell
reference (the $ sign) in a formula ?

Thanks,
Madhu
 
B

Bob Phillips

Madhu,,

F4 is the key you want. It cycles through all combinations, full absolute,
row absolute, column absolute, fully relative.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top