Absolute reference (F4 Key) not working

[makten86]

i've just installed a new wireless microsoft keyboard and in excel it won't
recongise me pushing f4 in the formula to change a cell reference to
absolute????

but outside of the formula it lets me push it and opens a new workbook.....

is there neway i can solve this delima without trying to uninstalling excel
and reinstalling it???

Thanks
Martin

 

[William Hamilton]

i've just installed a new wireless microsoft keyboard and in excel it won't
recongise me pushing f4 in the formula to change a cell reference to
absolute????

but outside of the formula it lets me push it and opens a new workbook.....

is there neway i can solve this delima without trying to uninstalling excel
and reinstalling it???

Thanks
Martin

Until you resolve it you could manually add $ in the formula to fix the
cell reference eg: $A$1

W

 

[makten86]

i know that, but its just a nuscence when i can just push F4 the question
wasn't how can i get around it... but how can resolve it. Thanks neway

 

[Dana DeLouis]

i've just installed a new wireless microsoft keyboard and in excel it
Sounds to me like you have the "F Lock" key toggled OFF.
Try turning the F Lock key back on.
Hopefully and easy fix ??


As a side note, didn't you want to wait for Microsoft's new $300 Keyboard?
Just kidding.
http://www.microsoft.com/hardware/mouseandkeyboard/ProductDetails.aspx?pid=080
One article said it was missing some basic keyboard features, whatever that
meant.

 

[makten86]

Thanks i found that out after seeing the F Lock key on my keyboard what a
stupid key, i suppose its there for those that dn't know the keyboard
shortcuts

 

[Karen Unger, AmDoc]

I've been DESPERATE because all of a sudden both my F4 and F2 keys (which I
use constantly in Excel) were acting weird. THANK YOU THANK YOU THANK
YOU......

Having these boards makes a difference in details.