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 was able to solve this by moving my Excel file to larger monitor. Here's what I did:
1) close the file with the problem (it was displayed on my laptop monitor)
2) close Excel
3) open Excel in a different display (I opened on a large 2nd monitor)
4) open the file
5) the dropdown now worked
Still doesn't work for me if I move the file back to the small monitor...
- 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.
