View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T Kirtley T Kirtley is offline
external usenet poster
 
Posts: 82
Default Keyboard shortcut for formula bar?

Is there a keyboard shortcut, (or vba method) that opens the formula bar to
edit the active cell? I want to keep the option of editing within a cell, as
is my default for the F2 key, but oftentimes when editing within a cell the
panel that opens to display/edit the cell contents obscures the view of the
nearby cells.

Editing cell contents within the formula bar resolves this, but I would like
to eliminate the need for a mouse click to open the formula bar.

Thanks for any suggestions.

TK