Home

Microsoft Excel 2010@

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Misc

Move to the Right When Pressing Enter

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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Misc page.

Print this tip.

- Subscribe!

Search the Site: