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 "F2" - formula look up

You probably have checked ToolsOptions, Edit tab, Edit directly in cell. Uncheck it to get F2 editing on the formula bar back.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gecko" wrote in message ...
| Hi,
|
| I'm unable to use the F2 key anymore to look up which cells are used in a
| formula, but when I go into the 'formula cell', I can see the colored cells.
|
| Any idea how I can have the F2 key fixed ?
|
| Thanks !
|