Forum Discussion
Cant click on drop down arrow
- 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
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.