This is something that has bothered many Excel users and one of the reasons I wanted to share this article with you.
Have you ever found yourself working within a dialog box in Excel? Of course you have! The problem arises when you are trying to move your cursor to edit a formula using your arrow keys. What happens? A reference to the cell on your worksheet is inserted into your formula!
Sometimes we just cannot see the forest for the trees!
Here is why the above problem occurs:
- When editing a formula within a dialog box, we need to look to the far left side of our Status Bar.
- There, you should see the words Add and/or Point.
- Using your arrow key at this juncture will insert a cell reference into your formula.
- To stop this from occurring, you must first click the F2 function key on your keyboard which will move you into Edit mode.
- You will now note the word Edit on the left-hand side of your Status Bar.
- In Edit mode, you can now use your arrow keys to edit your formula!