In Excel 2003, the option is Move Selection After Enter.
You can choose Right, Left, Up, and Down. In the Editing Options section, choose Right from the Direction dropdown under the After Pressing Enter, Move Selection option, as shown.In Excel 2003, choose Options from the Tools menu. In Excel 2007, click the Office button, and then click Excel Options. Click the File tab and then click Options (under Help).Pressing Tab is a bit easier than stretching for the right arrow key, but perhaps the easiest solution is to change the cursor movement as follows: Now, you can press the right arrow key instead of Enter, but doing so will slow you down. If you're entering data from column to column, it can be downright infuriating. That's not always the direction you'll want to go. Fortunately, you can get Excel to work with you instead of against you, if you know these quick tips for controlling the cursor's movements.įirst, Excel moves the cursor down to the next cell when you press Enter. Data entry can be a thankless job and if Excel doesn't cooperate, it can be a hateful job.
