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