View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
William Hamilton William Hamilton is offline
external usenet poster
 
Posts: 2
Default Absolute reference (F4 Key) not working

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