ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Shortcut for entering $ within a cell (https://www.excelbanter.com/excel-worksheet-functions/107488-shortcut-entering-%24-within-cell.html)

Linda H

Shortcut for entering $ within a cell
 
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.

MartinW

Shortcut for entering $ within a cell
 
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



Linda H

Shortcut for entering $ within a cell
 
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.

"MartinW" wrote:

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





All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com