Forum Discussion
Solved
Cant click on drop down arrow
HI, I am using Excel 2010 and I have created a data validation cell based on list of values from a set of given values. I am now unable to click on the arrow. I have checked that the in-cell drop ...
- noahwass FYI I think I found the cause (for my case anyway): if you have multiple displays and they are at different screen resolutions (external monitor at 100%, laptop at 120%), the dropdowns and other Excel features will not work properly on the display that is not set to 100%.
https://answers.microsoft.com/en-us/msoffice/forum/all/data-validation-list-dropdown-arrow-cannot-be/85b25ab5-9e25-4027-9fd3-4e9331bcda26
I am having the same problem, and have ruled out all the potential causes in all available help documentation. This appears to be a system bug, from it's inconsistent behavior on my machine, in unrelated files and different data validation source types.
Microsoft makes it so impossible to report bugs, that we all are wasting hours trying to get to the bottom of what is probably a known issue 🤦:female_sign:
Microsoft makes it so impossible to report bugs, that we all are wasting hours trying to get to the bottom of what is probably a known issue 🤦:female_sign: