Unexpected Behavior When Entering Data and Using Navigation Keys

• Microsoft Excel for Windows, version 4.0, 4.0a, 5.0

SYMPTOMS

In Microsoft Excel, when the Transition Navigation Keys (Alternate Navigation Keys in Microsoft Excel 4.0) check box is selected, you may experience unexpected behavior when you use certain keys and key combinations or when you enter text or formulas in cells.

For example you may experience the following:

• Keys used for moving around on a worksheet or macro sheet produce different results. These keys include: CTRL+LEFT ARROW, CTRL+RIGHT ARROW, TAB, SHIFT+TAB, HOME, CTRL+HOME, and END.
• Characters can be aligned in cells using the standard Lotus alignment characters which include: ", ^, \ (double quotation mark, caret, and backslash).

CAUSE

The Transition Navigation Keys (Alternate Navigation Keys in Microsoft Excel 4.0) option changes the functionality of certain keys and key combinations; it also changes the way formulas and text are entered in cells. You may experience unexpected behavior if this option has been enabled.

This option can be set in either of the following ways:

• When you install Microsoft Excel, choose the Enable Help For Lotus 1-2-3 Users option

  -or-

• Select the Transition Navigation Keys (Microsoft Excel 5.0) or the Alternate Navigation Keys (Microsoft Excel 4.0) check box.

WORKAROUND

To return to normal Microsoft Excel functionality, follow the appropriate procedures below to disable this option.

If you are using Microsoft Excel Version 5.0

1. From the Tools menu, choose Options.

2. Select the Transition tab, and under Settings, clear the Transition Navigation Keys check box. Choose OK.

1. From the Options menu, choose Workspace.

2. Clear the Alternate Navigation Keys check box, and choose OK.

REFERENCES

"User's Guide," version 5.0, pages 35-36

"User's Guide 1," version 4.0, pages 568-570