Problem: There are a few maddening dialog boxes in Excel. Say that you define a name and later need to edit that name. Click somewhere in the RefEdit box. When you press the left or right arrow key to move to another part of the cell, Excel starts inserting cell references.
Here is an example:
- You meant to click inside the parenthesis, but you missed.
When you press the right arrow key to move the flashing insertion point after the address, Excel starts inserting cell references. The only action between the figure above and the one below is pressing the right arrow.
- Excel inserts cell references as you arrow through.
This is maddening! The solution is very simple, though. Before you touch the arrow keys in a RefEdit box, press F2. You will see the status indicator in the lower left corner of Excel change from Enter or Point to Edit. Once you are in Edit mode, you can use arrow keys.
- Press F2 to change Point to Edit. Problem solved.