Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Recording a Macro

Adding a Little Animation to Your Life

Converting a Range of URLs to Hyperlinks

Making the Formula Bar Persistent

Engineering Calculations

Digital Signatures for Macros

Fixing the Decimal Point

 

Tab Key Jumps a Screen at a Time

Summary: Have you ever pressed the Tab key, expecting to move to the next cell in your worksheet, only to have Excel completely change what you see on the screen? This could be due to a setting deep inside Excel related to transitioning from other spreadsheet programs. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

In Excel, different keys have different purposes when it comes to navigating around your worksheet. Normally, when you press the Tab key you will notice that Excel moves the cell cursor one column to the right. Not all spreadsheet programs behave this way, however. For instance, when you press the Tab key in Lotus 1-2-3, the cell cursor jumps a full screen to the right, instead of a single column.

Excel, in its efforts to make life easier on people who are just changing to the program, will emulate the navigation keys used by Lotus 1-2-3. If you press the Tab key in Excel, and the cell cursor jumps one screen to the right, then your system is using the navigation emulator instead of the native Excel navigation keys. To change back to the Excel defaults, follow these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. At the left side of the dialog box click Advanced.
  3. Scroll through the list of available options until you see the Lotus Compatibility options.
  4. Clear the Transition Navigation Keys check box.
  5. Click on OK.

If you are using a version of Excel prior to Excel 2007, follow these steps instead:

  1. Choose Options from the Tools menu. Excel displays the Options dialog box.
  2. Make sure the Transition tab is selected. (Click here to see a related figure.)
  3. Clear the Transition Navigation Keys check box.
  4. Click on OK.

That's it. Your Tab key should now work as expected, moving one column to the right each time you press it.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2747) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!
 
Check out ExcelTips Archives today!