Forum Discussion
Jasmine1111
Oct 27, 2020Copper Contributor
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 ...
- Nov 17, 2021noahwass 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
AMayo1001
Dec 02, 2022Copper Contributor
Just had same problem, reopened an excel file from a few months back, resaved with a new name, then tried to use the existing drop downs referencing data in named range and the arrows stopped working. I was working on the file on my secondary (larger monitor) display. Reading your post I moved the window to my MacBook Air display and the data validation arrows now work. Strange.
timcox99
Dec 02, 2022Copper Contributor
AMayo1001 Awesome! That does in fact work for me. Can't explain why, but moving the Excel file to the 2nd screen solved the issue. Now that I read (and do) this, I recall having seen this solve some other issue a year or two ago. A good thing to try with future hard to solve Excel "bugs".