Tab Key Jumps a Screen at a Time

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. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 and later versions, display the File tab of the ribbon and then click Options.)
  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. (See Figure 1.)
  4. Figure 1. The Advanced options in the Excel Options dialog box.

  5. Clear the Transition Navigation Keys check box.
  6. 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.