Office for Mac Issues

Fix Excel for Mac Drop-Down Lists on an External Monitor

Natalie TaylorNatalie Taylor Nov 14, 2026 869 views

Question details

The user needs Excel for Mac drop-down lists to work when the workbook is displayed on an external monitor.

Fix Excel for Mac Drop-Down Lists on an External Monitor
Product
Microsoft Excel for Mac
Device & OS
MacBook running macOS; version not provided
Scenario
A workbook with drop-down lists is being used on an external monitor connected to a MacBook.
Observed behavior
The lists work on the MacBook display but do not open or show blank options on the external monitor. The issue was reported with Excel version 16.28.
Before you start

Open the affected workbook and identify a cell with a drop-down list. Confirm that the list works on the MacBook display before testing it on the external monitor.

Solution 1Recommended

Update Excel and test the external display settings

Use this approach to check the Excel version, install available updates, and test whether the monitor connection or scaling affects the lists.

1
Check the Excel version

In Excel, select Excel > About Excel and note the version number. The reported issue occurred with version 16.28.

2
Install Office updates

In Excel, select Help > Check for Updates and install any available Office updates. Restart Excel after the updates are installed.

3
Reconnect the monitor

Disconnect the external display from the MacBook, reconnect it, and move the Excel workbook back to the external screen. Click the affected drop-down cell to test it.

4
Test display settings

Open Apple menu > System Settings > Displays, or System Preferences > Displays on older macOS versions. Try a different resolution or scaling option for the external monitor, then restart Excel and test the list again.

Update Excel and test the external display settings
If the issue continues: Record the Excel and macOS versions, monitor connection type, display resolution or scaling, and affected workbook details for further troubleshooting.
Free Microsoft Office alternative

Try WPS Spreadsheets as an Excel Alternative on Mac

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for an easier transition. Open your workbook in WPS Spreadsheets and test its drop-down lists on the external monitor; WPS does not repair Excel itself.

Open and edit spreadsheets with a familiar interfaceCompatible with Microsoft Excel formats, including XLSX and XLSTest workbook drop-down lists in an alternative spreadsheet applicationFree and lightweight for everyday Office tasks
microsoft office alternative - wps office

Frequently Asked Questions

How do I check my Excel version on a Mac?

Open Excel and select Excel > About Excel from the menu bar. The version number appears in the About window.

Where can I change the external monitor's resolution?

Open Apple menu > System Settings > Displays, or System Preferences > Displays on older macOS versions. Select the external display and try another resolution or scaling option.

Why should I test the same drop-down list on both displays?

Moving the same Excel window between the MacBook and external display helps determine whether the behavior changes with the screen rather than the selected cell.

What information should I collect if the lists still do not work?

Note the Excel version from Excel > About Excel, the macOS version from Apple menu > About This Mac, the monitor connection type and display settings, and whether other workbooks are affected.