View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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