Sep 17 2019 06:34 AM
Sep 17 2019 06:46 AM
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.
Sep 17 2019 07:18 AM
Sep 17 2019 07:48 AM
They can be inserted through Developer Tab and if you don't have Developer Tab on the ribbon, here is how to show the Developer Tab.
And this is how you may insert a ComboBox on the Sheet and set it's properties.
Sep 17 2019 08:47 AM
You're welcome!
Please don't forget to choose the post which helped you to resolve your question as a Best Answer/Response to mark your question as Solved.