How to Fix Excel Data Validation Drop-Down Arrow Not Clickable
Question details
The user is unable to click the data validation drop-down arrow in Excel, a problem frequently caused by display scaling issues on high-DPI or multi-monitor setups.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to select an item from a data validation drop-down list on a high-DPI display or secondary monitor.
- Observed behavior
- The drop-down arrow appears on the screen, but it is entirely unresponsive to mouse clicks because Windows display scaling misplaces the target hit area.
Before troubleshooting, verify whether the drop-down arrow responds to keyboard inputs (like Alt + Down Arrow) to confirm the list data is still intact.
Adjust Windows Display Scaling to 100%
Since the unclickable arrow is caused by an Excel and Windows high-DPI scaling bug, setting your display scaling back to 100% restores the correct hit area.
Windows scales applications to make them readable on high-resolution screens. However, this scaling can occasionally offset interactive elements in Excel, such as the data validation drop-down arrow, causing your clicks to miss the actual target.
Right-click anywhere on your empty Windows desktop and select 'Display settings' from the context menu.
Scroll down to the 'Scale and layout' section and click the drop-down menu under 'Scale'. Change the value to 100%.
Close your Excel workbook and reopen it. Click the data validation drop-down arrow again to verify it works.

Use Keyboard Shortcuts or Context Menu Workarounds
If you cannot change your display scaling due to vision needs or screen resolution, use built-in keyboard shortcuts to open the list.
Report the Bug to Microsoft
Informing Microsoft about this display scaling bug helps their engineering team develop a permanent patch for Excel.
Try WPS Office to Avoid Display Scaling Glitches
If Excel display scaling bugs are continually interrupting your workflow on high-resolution monitors, switch to WPS Office. It provides a stable, lightweight environment with flawless rendering of spreadsheet elements.
- 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file without losing any data validation formatting.
- 3. Use Drop-Downs Flawlessly: Click the data validation drop-down arrows smoothly, regardless of your monitor's display scaling.

Frequently Asked Questions
Why does the Excel drop-down arrow work on one monitor but not another?
This occurs due to a known conflict between Excel and Windows display scaling. If your main laptop screen is scaled to 250% while your external monitor is at 100%, the clickable target area for the arrow becomes misplaced on the scaled screen.
Does 'Pick from Drop-down List' permanently fix the unclickable arrow?
No, it is only a temporary workaround. Using 'Pick from Drop-down List' allows you to select your data without relying on the unclickable arrow, but the scaling bug will remain until display settings are adjusted or Microsoft patches the software.
Will updating my Windows OS fix the Excel drop-down scaling issue?
Keeping Windows and Office updated is highly recommended, as Microsoft releases bug patches in these updates. However, if the issue persists after updating, reverting the display scaling to 100% remains the most reliable immediate fix.




