Fix Excel Mac Drop-Down List Not Showing on External Monitor
Question details
Users are experiencing display issues where data validation drop-down lists fail to appear or show in the wrong position when using specific external monitors.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Working with data validation drop-down lists in an Excel workbook displayed on a secondary or third external monitor.
- Observed behavior
- The drop-down list either completely disappears, renders in an incorrect screen location, or only functions properly when the Excel window is removed from full-screen mode on the affected monitor.
Verify your external monitor's connection and check if the drop-down list displays correctly on your MacBook's primary built-in screen to confirm it is a multi-monitor scaling issue.
Exit Full-Screen Mode and Update Software
Since the rendering glitch is heavily tied to full-screen scaling on specific external displays, resizing the window serves as the most reliable immediate workaround.
This is a known compatibility issue between Excel for Mac's UI rendering and certain external monitor configurations. Running the app in windowed mode avoids the conflicting full-screen scaling protocols in macOS.
Hover your cursor near the top left of the Excel window and click the green maximize/minimize button, or press Control + Command + F to switch to a standard window.
Drag the window slightly on your external monitor. Click the cell with the data validation rule again to see if the drop-down list now appears in the correct position.
Navigate to Apple Menu > System Preferences > Software Update for your Mac. Then, open Excel, click Help in the top menu bar, and select Check for Updates to install the latest bug fixes.
Use Alternate Methods to Select Data
If you need to keep working in full-screen mode, you can bypass the local monitor glitch by using the Mac Touch Bar or Excel for the Web.
Use WPS Office to Avoid Display Glitches on Mac
If Microsoft Excel continues to struggle with multi-monitor display scaling or UI bugs on your Mac, try WPS Office. It provides a highly compatible, lightweight spreadsheet environment that natively supports complex macOS setups without external monitor rendering issues.
- 1. Download and install: Visit the official WPS website to download the Mac version of WPS Office and install it on your device.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file.
- 3. Use drop-down lists flawlessly: Drag the WPS window to any external monitor. Click your data validation cells to use drop-down menus without position or visibility errors.
Frequently Asked Questions
Why does the Excel drop-down only work when not in full-screen mode?
This happens due to a UI rendering conflict between Excel for Mac and the native resolution scaling of certain external monitors. Exiting full-screen mode forces the application to render within standard macOS window bounds, which bypasses the display glitch.
Is my workbook corrupted if the drop-down list doesn't show?
No. If the drop-down list functions correctly on your built-in MacBook display or in Excel for the Web, the workbook is completely fine. The problem lies strictly with how the desktop application renders the interface on your specific external monitor.
Does this monitor issue affect other Microsoft Office Mac apps?
While it is most commonly reported with data validation drop-down lists in Excel, similar multi-monitor scaling bugs can occasionally cause floating menus or dialog boxes to misalign in Word or PowerPoint for Mac when used in full-screen mode.
