Office for Mac Issues

How to Fix Excel for Mac Tab and Enter Behavior with Drop-Down Lists

Algirdas Jasaitis Oct 8, 2026 869 views

Question details

The user is seeking a solution for the cursor returning to the wrong column when pressing Enter after tabbing through cells containing drop-down lists.

Fix Excel for Mac Tab and Enter Cursor Behavior with Drop-Down Lists

Product: Excel for Mac
Device & OS: macOS
Scenario: Entering data sequentially across rows using the Tab and Enter keys in a spreadsheet that includes data validation drop-down lists.
Observed behavior: Pressing Enter after tabbing past a drop-down list moves the cursor to the column with the drop-down instead of properly returning to the starting column of the next row. This occurs on Mac but not Windows.

Before you start

Ensure your macOS and Microsoft Excel applications are updated to the latest versions, as this specific behavior has been widely noted in version 16.81.

Solution 1Recommended

Check Excel Edit Preferences for the Return Key

Verify if adjusting the default cursor movement settings after pressing Return resolves or mitigates the issue.

While this specific drop-down list behavior is recognized as a bug in certain Mac versions, ensuring your core navigation settings are properly configured is the first troubleshooting step.

Open Excel Preferences

Launch Excel on your Mac, click on 'Excel' in the top Apple menu bar, and select 'Preferences' from the drop-down list.

Access Edit Settings

In the Preferences window, click on 'Edit' located under the Authoring section.

Adjust Return Key Behavior

Locate the setting labeled 'After pressing Return, move selection' and experiment with changing its direction to see if standard data entry behavior is restored.

Check Excel Edit Preferences for the Return Key

Known Limitation: If no setting corrects this specific behavior, it is a known version-specific limitation in Excel for Mac that does not occur on the Windows version.

Solution 2

Report the Issue via Microsoft Feedback

Report this reproducible bug directly to the Microsoft development team so they can prioritize a fix in future updates.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Data Entry on Mac

If unresolved Excel for Mac bugs are disrupting your workflow and you do not want to lose functionality by switching to Apple Numbers, consider using WPS Office. It provides a highly compatible spreadsheet environment with reliable keyboard navigation.

1. Install WPS Office: Download and install the free WPS Office suite for Mac from the official website.
2. Open Your Excel File: Open your existing .xlsx workbook directly in WPS Spreadsheets without losing any data or formatting.
3. Resume Data Entry: Continue inputting your data using Tab and Enter to experience normal, expected cursor behavior.

Flawless Tab and Enter keyboard navigation for rapid data entry without cursor glitches.Full compatibility with Microsoft Excel formats (.xlsx, .xls) and data validation lists.Free, lightweight, and optimized for smooth performance on macOS.

Frequently Asked Questions

Why does the cursor jump to the wrong column in Excel for Mac?

This is a known bug in certain versions of Excel for Mac (such as version 16.81) where having a data validation drop-down list in a cell disrupts the standard Tab and Enter carriage return sequence.

Does this Tab and Enter cursor issue happen on the Windows version of Excel?

No, this specific Tab and Enter behavior with drop-down lists has been widely confirmed to only occur on the macOS version of Excel. The Windows version correctly returns the cursor to the starting column.

Can I fix this by changing the Return key direction in Excel settings?

You can try changing the 'After pressing Return, move selection' setting in Excel Preferences > Edit, but many users have reported that this does not resolve the specific bug caused by drop-down lists.

Office App Problems