Fix Lotus Compatibility Navigation Keys in Excel for Microsoft 365
Question details
Restore Lotus-compatible navigation shortcuts that stopped working 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.
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.
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.
In Excel, open File > Options > Advanced. Under Lotus compatibility settings for the selected worksheet, check Transition navigation keys, then select OK.
Select a cell in the affected worksheet, press End, and then press Down Arrow. Check whether the selection moves as expected.
On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Open the affected workbook and test the shortcut again.
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.
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.
Run an Online Repair of Microsoft 365 on Windows
Use Online Repair if checking settings and disabling suspected add-ins do not resolve the issue.
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.

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.




