"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

Microsoft Excel 2010

Working on a Wide Worksheet? Make ENTER Move to the Right

SUMMARY: If you're editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.

By default, when editing a worksheet in Microsoft Excel 2010, you can press the Tab key to move the selection cursor to the cell to the right, and Enter moves to the below cell.

If you're editing a wide worksheet with a 10-key, you might find it more convenient to have the Enter key move to the cell to the right, just like the Tab key. The following shows you how to make this change. In fact, you can have Enter move up or to the left, if desired:

1. Select the "File" tab in the Ribbon.

2. The Microsoft Office Backstage View appears. Click the "Options" button.

(Or instead of steps 1 and 2, press Alt + T, then the letter O.)

3. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.

4. In the right pane, underneath "Editing Options", make sure "After pressing Enter, move selection" is checked.

5. Underneath, click the pull-down next to "Direction" and choose the desired direction the cell selection should move after pressing Enter.

Changing the cell selection direction when pressing the Enter key

6. Click "OK" on the bottom-right of the dialog box to close it.

Return to the Microsoft Excel 2010 page.

Print this tip

Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!

Newest Tips:

Google Chrome
[MODIFIED] Add Button to Scroll to Top of Long Web Pages
Google Gmail
Show Maps Automatically in Emails Instead of Copying and Pasting
Windows 8
Shrink the Taskbar Buttons
Sites to Browse - DVDs - Movies
[MODIFIED] Learn to Talk like Yoda

Follow Us!

About MalekTips and the Author

The MalekTips website was created in 1998 by Andrew Malek of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.