View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Switch between relative, absolute, and mixed references

Hi Connie,

It is still F4.

Maybe you got the new version of Excel with a new PC, with a keyboard with
multifunction function keys?
If so, press F Lock to enable the "normal" behavior of function keys.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Connie" wrote in message
...
In Excel 2003 I used F4 to Switch between relative, absolute, and mixed
references. Is there another shortcut to do this in 2007???