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


"Dana DeLouis" wrote:

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

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/mo...s.aspx?pid=080
One article said it was missing some basic keyboard features, whatever that
meant.
--
HTH :)
Dana DeLouis


"makten86" wrote in message
...
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

"William Hamilton" wrote:

makten86 wrote:
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