Excel Formula Dialog Frustration Solved

Make editing easy

In many Excel dialogs when you use the arrow keys to move around the formula you actually insert cell references from the active cell in the sheet below.

This is frustrating as you usually only want to move within the formula and you might have to exit out of the dialog and start again.

The problem is that when the dialog activates, Excel is in Point mode. See under the sheet tab names in the image below.

This means that any arrow key movements are treated as movements of the active cell on the sheet and the cell reference is inserted in the formula.

The easy way to get out of Point mode is to press the F2 function key.

Press F2

Once you press F2 Excel switches to Edit mode (see image above) and then you can use the arrow keys to move around the formula.

Frustration solved – please share.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

5 thoughts on “Excel Formula Dialog Frustration Solved

  1. Thanks. This has been bugging me for years. Point mode seems inappropriate for most dialog fields and can get you in a real mess. Can you get Excel to default to edit mode rather than hitting F2 every time?