Forum Discussion

Copper Contributor

Oct 27, 2020

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 ...

Drop Down not working.xlsx9 KB

excel

SaraBae
Nov 17, 2021
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

NikolinoDE

Platinum Contributor

Oct 27, 2020

Jasmine1111

Excel 2010:
File -> Options -> Advanced-> Group: Show options for this workbook: -> Show objects as: Select "All".

Then the dropdown functions will be back. 🙂

Ps. Recommend to do an Office update. As far as I can remember, that was an old bug which was actually fixed with a patch in the service pack ... even in 2010. Better safe than sorry, update.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.