F4 key does not toggle relative/absolute cell references.

J

java

I am using Office 2003 SP3, and am also using the Microsoft Natural Keyboard
Elite (which may be the problem). Using my F4 key to toggle between relative
and absolute cell references does not toggle as expected; in fact there is no
toggling performed. I had no trouble with a standard keyboard, but when I
switched to the Microsoft Natural Keyboard, the F4 key no longer works as
expect.

Is anyone aware of a fix for this problem
 
R

Ron de Bruin

Hi Java

Do you have F Lock key on that keyboard (next to F12)
Press it one time to get the normal behavior back

I don't like it also (I have a wireless Microsoft Natural Keyboard myself)
 
N

Niek Otten

I don't know about your keyboard, but on mine I always have to press F Lock,
so that the related light goes on and the keys work as Function keys.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 

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

Excel 2002 - Toggle between absolute and relative cell reference 0
Absolute cell reference (F4 Key) 2
Help with converting a block of cells with Absolute and mixed references to relative references 3
Absolute and Relative Cell References 1
Using icon sets with relative references 0
Cell Reference Keyboard Shortcut unavailable 1
Absolute reference (F4 Key) not working 5
Change relative to absolute references in a block of cells 3

Top