| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Hybrid Mode
