Alternate from editing cell to formula cell

[Guest]

I was wondering if anyone knew the quick key for alternating from the active cell to the formula bar?

To clarify, I know if I press <F2> it allows me to edit the cell directly. I believe there is a short cut key to toggle between editing the cell directly and editing the cell in the formula bar. When I have several lines to text within say row 1 or 2, I find it easier to edit in the formula bar since otherwise the formula bar covers up the cell. I know you can just click on the formula bar, but I was wondering if there is a quick key as well.

Thanks.

 

[Peo Sjoblom]

If you do tools>option>edit and uncheck edit directly in cell, then F2 will
put you in edit mode in the formula bar.
You can't have it both ways though. So you can either hide the formula bar
and
it won't cover the cell or you can uncheck the edit directly in cell

--

Regards,

Peo Sjoblom

I was wondering if anyone knew the quick key for alternating from the

active cell to the formula bar?

To clarify, I know if I press <F2> it allows me to edit the cell directly.

I believe there is a short cut key to toggle between editing the cell
directly and editing the cell in the formula bar. When I have several lines
to text within say row 1 or 2, I find it easier to edit in the formula bar
since otherwise the formula bar covers up the cell. I know you can just
click on the formula bar, but I was wondering if there is a quick key as
well.

 

[Guest]

Just wondering if you are sure? In training, I could almost swear I remember an Excel instructor showing us how to toggle between the cell and formula bar using a quick key.

 

[Peo Sjoblom]

Yes I am sure

--

Regards,

Peo Sjoblom

Just wondering if you are sure? In training, I could almost swear I

remember an Excel instructor showing us how to toggle between the cell and
formula bar using a quick key.

 

[Gord Dibben]

MG

Perhaps your instructor had a macro with a hotkey.

Sub Toggle_Edit()
With ActiveWindow
If Application.EditDirectlyInCell = False Then
Application.EditDirectlyInCell = True
Else: Application.EditDirectlyInCell = False
End If
End With
End Sub

Gord Dibben Excel MVP