Absolute cell reference

  • Thread starter Thread starter Madhu Ramamurthy
  • Start date Start date
M

Madhu Ramamurthy

Hi ,

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

Thanks,
Madhu
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

absolute reference fill 1
Copy and paste absolute reference 3
"Relative" Absolute Cell References in Excel 2007 4
Shortcut to change change cell reference to Absolute reference? 12
Is there a way to copy cells with absolute reference gettingadjusted? 3
Absolute Sheet Reference 3
Absolute References and worksheets 0
Worksheet relative reference 3

Back
Top