When I press F2 in a cell I can edit it inside the cell. However often it's just more convenient to make the edit in the formula bar.
I can switch to formula bar by mouse, just wondering whether there is a keyboard shortcut for that?
when editing in formula bar, highlights are applied there and also cursor blinks there:
1 Answer
In the Excel options menu, turn off the option Allow editing directly in cells. Now when you press F2, you'll always be editing in the Formula bar.
I don't believe there's a keyboard-based solution to this.
