Forum Discussion
Cant click on drop down arrow
- 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
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.
Old post, but this was extremely helpful for an issue I had encountered!
Not sure when the setting changed for me, but this certainly resolved the frustrating issue I had with drop-downs.
For later Excel version Office 365 reference, the navigation is as follows:
File > Advanced:
Under the "Display options for this workbook" sub-header there is the option "For objects, show:"
Select "All"
Thanks again!
This was an awesome discovery. I did not find the answer until I continued reading.
Mine was working until it wasn't. I realized after read that I had zoomed the workbook. Putting the zoom back to 100%, changing monitors, close/open, copy workbook, clear validation,... nothing worked. Did not find until I got to this post where to find the appropriate section. Question remains, why did it get changed from All to Nothing? Thanks Trahllah.- Thanks for your feedback, I'm glad you found a solution and are posting it here.
I wish you continued success with Excel!
