Data validation list dropdown arrow cannot be selected

Right click the cell and then Pick From Drop-down list does not work for me either.

However, left click the DropDown arrow does work so suggest that you try that.

I will research a little more and see if I can identify the reason.

@OssieMac left-clicking the dropdown arrow is the standard path, and what my entire question is about, because it is not working.

I only included the information about 'Pick from Drop-down' to explain that I cannot even use that as a workaround.

Hi Sara,

May I know if this happening with new workbook or the existing ones are all affected?

For the test purpose, please create a new workbook and save it to your local computer (not in SharePoint library) and then apply Data Validation. This will us confirm if the issue is with the workbook stored in cloud or local workbooks are also creating the issue.

Besides, please provide the screenshot of Microsoft 365 Product Information. To get this screenshot, open Word or Excel on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information. 

Regards,

Neha

Hi Sara,

Did you check the above reply? If you still need help, pleaee update us.

Regards,

Neha

Neha,

I believe I have isolated the cause of the issue. I have been able to recreate it multiple times, and resolve it as well.

The issue is that the target zone of the drop-down list arrow is not scaling correctly for displays at a higher scale (zoom).

I have a multiple-monitor setup, using an external monitor at 100% scaling (recommended), and my PC's built-in display at 250% scaling (recommended).

When the workbook is open on the built-in display at 250% scaling, the dropdown arrows are not selectable, but when I move it to the external monitor at 100% scaling, they work as expected.

Neha, if you could report this bug to the Windows 10 and Excel teams, I would appreciate it, because I would like my programs to work on all displays.

My system and Excel version details below.

Thank you for posting the solution that you found. I doubt that anyone else would have found that.

You can report the problem yourself via Feedback.

Open Excel

Select File - > Feedback

Click "Send a frown" and follow the prompts

Hi Sara,

Thanks for sharing the solution with the community, I am sure it will help someone who has the same issue.

Regarding reporting the issue, the quickest route to our developers’ ears is right from within Office app. In Excel, click File > Feedback and send the feedback directly to the Product group. This will have more impact on the Product Group as the feedback is coming directly from the customer.

Kind Regards,

Neha