Absolute reference (F4 Key) not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
makten86 said:
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
Click to expand...
Until you resolve it you could manually add $ in the formula to fix the
cell reference eg: $A$1

W
 
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
 
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
 
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.
 
Back
Top