'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Drop-Down Menus Not Working on Mac External Monitor
Question details
Users experience an issue where Excel drop-down menus fail to display or appear in an incorrect position when the application window is moved to an external monitor.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Working with data validation lists or application drop-down menus in Excel on a secondary external display.
- Observed behavior
- Drop-down menus either completely disappear when clicked or render misaligned, appearing far away from the actual drop-down arrow.
Save all open workbooks and ensure your macOS system settings are accessible before modifying monitor resolutions or clearing application cache data.
Restart Excel Directly on the External Monitor
This is the most effective workaround to recalibrate Excel's display rendering by forcing the application to launch directly on the affected screen.
Excel for Mac sometimes struggles to calculate the correct window coordinates when dragged from a Retina display to a standard external monitor. Restarting the application directly on the external screen forces it to adopt the correct resolution scaling.
Drag your open Microsoft Excel application window from your Mac's main screen to the external monitor.
Save your work, click 'Excel' in the top menu bar, and select 'Quit Excel' (or press Cmd + Q) to close the program completely.
Ensure your mouse cursor and active focus remain on the external monitor, then reopen Microsoft Excel and your workbook. Click the drop-down arrow to verify the menu appears correctly.
Adjust the External Monitor Resolution
Changing the resolution forces macOS to redraw the user interface, which can restore missing drop-down menus.
Reset the Microsoft Excel Container Cache
Removing corrupted or outdated cached application data can resolve persistent UI glitches in Office for Mac.
Try WPS Office for a Seamless Mac Display Experience
If Microsoft Excel continues to struggle with multi-monitor setups and scaling glitches on your Mac, WPS Office offers a highly compatible, free alternative. It handles external displays effortlessly while fully supporting your existing spreadsheets and data validation menus.
- 1. Download WPS Office: Get the free WPS Office installation package for macOS from the official website.
- 2. Open your spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file directly without any format conversion.
- 3. Use across any monitor: Drag the application across your Retina display and external monitors to enjoy flawless drop-down menus.
Frequently Asked Questions
Why do drop-down menus appear in the wrong position in Excel for Mac?
This happens due to a known display scaling conflict between the Mac's built-in Retina display and the external monitor. Excel miscalculates the screen coordinates, causing it to render the drop-down list far away from the actual cell.
Does changing the display scaling to 100% fix the Excel menu issue?
Setting both the Mac display and the external monitor to exactly 100% scaling can sometimes resolve the coordinate error. However, simply restarting the Excel application directly on the external monitor is usually the most reliable fix.
Will deleting the Excel container delete my spreadsheets?
No, moving or deleting the Microsoft Excel container from the '~/Library/Containers' directory only clears cached data and application settings. Your personal workbooks and documents saved on your drive or in the cloud will remain completely safe.
