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 had a similar issue. I had an external monitor (85" screen) connected as an extended monitor. With the Excel spreadsheet on this screen, the cursor stayed as a cross when hovering over the drop down list. When I moved the spreadsheet to my laptop screen, the cursor changed to a pointer when hovering over the drop down list.
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
https://answers.microsoft.com/en-us/msoffice/forum/all/data-validation-list-dropdown-arrow-cannot-be/85b25ab5-9e25-4027-9fd3-4e9331bcda26
- This is what I found to be the problem for me too.
I had this problem, I am using two external monitors and my laptop monitor. I tried many of the different approaches mentioned here, all my settings were correct. I had very limited success opening up old versions, but as soon as I saved or updated my data, the dropdown would no longer drop down.
I eventually closed the several excel windows I had open, then opened up the same file from File Explorer and the dropdowns were working again. This was all on the same external monitor, I never tried playing around with display settings.
Windows 11
