View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default MAC shortcut key

Hi Folks,

Does anyone know if there is a shortcut key on the MAC which duplicates the
F9 key when one is in the Edit mode - On the PC this key converts the formula
or portion of the formula to a value. For example, if you highlight the
TODAY() portion of the formula =TODAY()+7*ROW(A1)-7 and press F9 Excel will
display 39224. F9 does not work on the MAC as far as I can tell.

--
Thanks,
Shane Devenshire