Shortcut for entering $ within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use to know the shortcut keys for entering the the dollar sign symbol into
a formula quickly. I am working with a lot of absolue formulas and the
shortcut keys will really help me.
 
Hi Linda,

F4 is what you are looking for just click in your cell
reference in the formula bar and hit F4. It cycles through
four options just keep tapping it till you get the
configuration you want.

HTH
Martin
 
Thank you very much, I was browsing some other posts and located the answer
(of course after I posted this question) but I really appreciate the quick
response.
 

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

Windows 10 How to create individual shortcut for each user 1
Excel Shortcut to go to the page/document referenced within a cell in excel 0
Absolute value with a quick formula / shortcut? 3
CELL("filename") doesn't work on shortcut workbook link? 12
Is there a one button shortcut for "copy cell above & paste here" 4
Re: Convert Array Formulas to Regular Formulas 0
Excel changes spelling of word 2
shortcut key for selecting the inactive cells surrounding a range 1

Back
Top