Alternate from editing cell to formula cell


G

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.
 
Ad

Advertisements

P

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


MG said:
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.
 
G

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.
 
P

Peo Sjoblom

Yes I am sure

--

Regards,

Peo Sjoblom


MG said:
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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top