Summary: Help perform data entry in Microsoft Excel 2003 by column instead of by row.
If you perform a lot of data entry in Microsoft Excel 2003, you may have noticed that after pressing ENTER, your cursor moves down to the next row so you can enter information there. However, if you work more in a left-to-right than top-down paradigm, you might rather the cursor move to the next cell to the right upon pressing ENTER. This can be changed easily.
1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.
3. Underneath "Move selection after Enter", click on the pull-down next to "Direction", changing it to "Right".
4. Click "OK" to close the dialog box.
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Misc page.
Search the Site: