Office Settings & Configuration

How to Fix Excel Data Validation Drop-Down Arrow Not Clickable

Nimra MalikNimra Malik Nov 4, 2026 868 views

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.

How to Fix Excel Data Validation Drop-Down Arrow That Cannot Be Clicked
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 you start

Before troubleshooting, verify whether the drop-down arrow responds to keyboard inputs (like Alt + Down Arrow) to confirm the list data is still intact.

Solution 1Recommended

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.

1
Open Display Settings

Right-click anywhere on your empty Windows desktop and select 'Display settings' from the context menu.

2
Modify the Scale Percentage

Scroll down to the 'Scale and layout' section and click the drop-down menu under 'Scale'. Change the value to 100%.

3
Restart Excel

Close your Excel workbook and reopen it. Click the data validation drop-down arrow again to verify it works.

Adjust Windows Display Scaling to 100%
Multi-Monitor Setup: If you are using multiple monitors, you can simply drag the Excel window to a secondary monitor that is already configured to 100% display scaling.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
  2. 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file without losing any data validation formatting.
  3. 3. Use Drop-Downs Flawlessly: Click the data validation drop-down arrows smoothly, regardless of your monitor's display scaling.
100% format compatibility with Microsoft Excel (.xlsx) filesAccurate rendering of data validation drop-downs on high-DPI screensLightweight, fast performance, and free to useFamiliar user interface requiring zero learning curve
microsoft office alternative - wps office

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.