Not sure about you, but I find it really annoying when you are editing a formula in a dialog box, and you try to move the cursor by pressing the arrow keys, and Excel decides to insert a cell reference in your formula rather than moving the cursor to the part of the formula you want to edit. Grrrrrr!!
So, is the only way to get around this to point and select with the mouse pointer seeing as pressing the arrow keys just keeps adding cells form your worksheet.?
Well, not if you understand the difference between Edit and Enter mode. Look to the bottom left of your Excel Window, you will probably see Enter. All you need to do is go into Edit mode, and this is done by firstly pressing the F2 key on your keyboard. You will now notice that the word Edit will appear in the status bar.
So remember press F2 to get into Edit Mode to edit a formula and Excel will allow you to easily edit your formulas in dialog boxes. Give it a go.