Forum Discussion
Jasmine1111
Oct 27, 2020Copper Contributor
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 ...
- 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
NikolinoDE
Oct 27, 2020Gold Contributor
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.
Jasmine1111
Oct 28, 2020Copper Contributor
NikolinoDE HI Nikolino,
Sorry, in the Advance Option, there is no Group so I couldnt do what you suggested. And I mistook, my version is not 2010 but 2019 😉
I ran an update, logoff and relogin but problem still exists.
I wonder if I delete the software and reload with the code, will that work?
Thanks
Jasmine
- NikolinoDEAug 07, 2021Gold Contributor
So with me I can open it, as Mr. Hans Vogelaar also describes it.
You might be lucky with this correction instruction.
How to show drop down list’s disappeared arrows again in Excel?
In some cases, the arrow of drop down list disappears because the option called In-cell dropdown is not checked.
- Select the drop down list cells and click Data > Data Validation.
- In the Data Validation dialog, under Settings tab, go to check In-cell dropdown option.
- Clock OK to close dialog, and you can see the arrow of drop down list has been shown.
If all of this does not work out, make a Windows update and an Office update to be on the safe side. If this doesn't work either, then ... halleluia, uninstall and reinstall the office package.
Hope it doesn't come to that and be lucky with the correction instructions.