Office Settings & Configuration

Fix Lotus Compatibility Navigation Keys in Excel for Microsoft 365

Phi Hung VoPhi Hung Vo Nov 14, 2026 868 views

Question details

Restore Lotus-compatible navigation shortcuts that stopped working in Excel for Microsoft 365.

Fix Lotus Compatibility Navigation Keys in Excel for Microsoft 365
Product
Excel for Microsoft 365
Device & OS
not provided
Scenario
The user relies on Lotus Transition navigation keys to move around a worksheet.
Observed behavior
End followed by Down Arrow and other Lotus navigation keys no longer work as expected.
Before you start

Check whether the shortcuts fail in one workbook or in multiple workbooks, and note what happens when you press them. In Excel, open File > Account to find your Office version if you need to report the issue.

Solution 1Recommended

Check the Lotus navigation setting and test Excel in Safe Mode

Confirm the worksheet setting, then use Safe Mode to check for interference from add-ins or other startup components.

1
Check the navigation setting

In Excel, open File > Options > Advanced. Under Lotus compatibility settings for the selected worksheet, check Transition navigation keys, then select OK.

2
Test the shortcut

Select a cell in the affected worksheet, press End, and then press Down Arrow. Check whether the selection moves as expected.

3
Start Excel in Safe Mode

On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and test the shortcut again.

4
Isolate add-ins

If the shortcut works in Safe Mode, restart Excel normally and open File > Options > Add-ins. Select COM Add-ins in the Manage list, choose Go, and clear suspected add-ins. Restart Excel and test again; re-enable add-ins one at a time to identify the cause. Repeat with Excel Add-ins if needed.

5
Check workbook macros

If the issue is limited to a macro-enabled workbook, review its VBA macros. You can also open File > Options > Trust Center > Trust Center Settings > Macro Settings and use the notification option to test the workbook without enabling macros, if your organization allows it.

Safe Mode result: If the shortcut works in Safe Mode, an add-in or another component loaded during normal startup may be interfering. This test does not by itself identify the cause.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet files. Open your existing Excel files to make moving between office suites easier; WPS does not repair Excel's Lotus navigation settings.

Navigate and edit worksheets in WPS SpreadsheetsOpen and save Microsoft Excel formats such as XLSXUse a familiar interface for common spreadsheet tasksWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Lotus navigation setting in Excel?

Open File > Options > Advanced and find Lotus compatibility settings for the selected worksheet. Check Transition navigation keys and select OK.

How do I start Excel in Safe Mode?

On Windows, close Excel, press Windows+R, type excel /safe, and select OK. Open the workbook and test the shortcut.

What does it mean if the shortcut works in Safe Mode?

An add-in or another component loaded during normal startup may be interfering. Check add-ins under File > Options > Add-ins and test them one at a time.

How do I use End and Down Arrow in Excel?

Select a cell, press End, and then press Down Arrow. The resulting movement depends on the worksheet's data and navigation settings.

What information should I collect if the problem continues?

Check File > Account for the Office version, note whether the issue affects all workbooks, and record what happens when you use the shortcut.