Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Reference Keyboard Shortcut unavailable
I use a Microsoft Ergonomic 4000 keyboard, and the software that came with it
defaults the F4 key to "NEW". This seems to override the Excel (2003) default for F4 that cycles a cell reference from relative to absolute (A1 - A$1 - $A1 - $A$1). I do not need the "NEW" function, but I really want the relative/absolute function. How do I set it back, and can I set it back only for Excel (best answer) or does it have to apply to all applications (acceptable answer). Thanks in advance. I appreciate your help. Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Reference Keyboard Shortcut unavailable
Jason Tsang has a couple of .REG files that will allow you to reverse the
default behaviour of the F Lock key or disable it. One will change the default to "Off". http://mvps.org/jtsang/flock.html The other will eliminate the F Lock feature totally. This one I use!! http://mvps.org/jtsang/flock-e.html Both are Zips have an Undo.REG and a Readme.txt file with them. Gord Dibben Excel MVP On Fri, 6 Jun 2008 14:45:00 -0700, Mike wrote: I use a Microsoft Ergonomic 4000 keyboard, and the software that came with it defaults the F4 key to "NEW". This seems to override the Excel (2003) default for F4 that cycles a cell reference from relative to absolute (A1 - A$1 - $A1 - $A$1). I do not need the "NEW" function, but I really want the relative/absolute function. How do I set it back, and can I set it back only for Excel (best answer) or does it have to apply to all applications (acceptable answer). Thanks in advance. I appreciate your help. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the shortcut key for making a cell reference absolute? | Charts and Charting in Excel | |||
What is the key shortcut for absolute cell reference? | Excel Discussion (Misc queries) | |||
What is the shortcut key for adding $ to a cell reference eg $c$3 | Excel Worksheet Functions | |||
Is there a keyboard shortcut to center data in a cell? | Excel Worksheet Functions | |||
Keyboard shortcut for double click in Excell cell | Excel Discussion (Misc queries) |