Forum Discussion
Drop down box indicator help for novice
That is how a dropdown (data validation list) works. The dropdown arrow will only appear when the cell with dropdown is selected. To help the user to know that the cells have a dropdown in them, you may format those cells to have a visual clue for dropdowns.
It you have inserted the dropdown lists in few cells only and want the dropdown arrow to appear all the time, you may consider inserting the ComboBox from the Form Controls and specify the Input Range and the Linked Cells.
- WorkinprogressSep 17, 2019Copper ContributorThank you Subodh for your reply. Where do I find the combo box in form controls? Sorry.... really novice to using drop downs.
- Subodh_Tiwari_sktneerSep 17, 2019Silver Contributor
They can be inserted through Developer Tab and if you don't have Developer Tab on the ribbon, https://support.office.com/en-us/article/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45.
And this is how you may https://www.youtube.com/watch?v=6OtHMdTCeoQ on the Sheet and set it's properties.
- WorkinprogressSep 17, 2019Copper ContributorThanks! That helped.