17

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?

19

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.

  • 4
    where have you been all my life? – Chris Aug 27 '10 at 15:04
  • Glad it helped! Check out this page for additional shortcuts in excel: office.microsoft.com/en-us/excel-help/… – JNK Aug 27 '10 at 15:08
  • Small point - this doesn't work on the Mac version of Office 2016 – hydev Mar 9 '18 at 14:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.