In Excel's chart wizard, how can I use the arrow keys?
This has always bugged me: In the excel chart wizard (and many other places), when you are editing ranges to be used for data (e.g., the "Values" or "Name" fields), if I try to use the arrow keys to move around within that text, it ends up moving my active cell around in the worksheet and really hosing up the field that I'm editing. Therefore I end up using the mouse a great deal, which is slow and physically painful.
How can I make it so that my arrow key moves within the text I'm editing and not around the worksheet?
Use F2
.
It works in Excel 2007. When you hit F2
it toggles your cursor from the cell selection to the formula/line selection in either the current window or if you are not in a wizard, the formula bar.