Home

Drop down box indicator help for novice

%3CLINGO-SUB%20id%3D%22lingo-sub-858761%22%20slang%3D%22en-US%22%3EDrop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858761%22%20slang%3D%22en-US%22%3EI%20am%20making%20some%20drop%20down%20boxes%20but%20the%20drop%20down%20box%20arrow%20is%20not%20there%20when%20I%20click%20on%20another%20box%20in%20the%20Excel%20sheet.%20How%20do%20I%20make%20it%20show%20all%20the%20time%20so%20people%20know%20there%20is%20a%20drop%20down%20box%20there%3F%20Sorry%20for%20such%20a%20novice%20question.%20I%20thought%20I%20had%20decent%20excel%20skills%20until%20I%20started%20to%20do%20this%20and%20now%20I%20feel%20like%20I%20need%20to%20take%20excel%20101%20again.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-858761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858796%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858796%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410278%22%20target%3D%22_blank%22%3E%40Workinprogress%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20how%20a%20dropdown%20(data%20validation%20list)%20works.%20The%20dropdown%20arrow%20will%20only%20appear%20when%20the%20cell%20with%20dropdown%20is%20selected.%20To%20help%20the%20user%20to%20know%20that%20the%20cells%20have%20a%20dropdown%20in%20them%2C%20you%20may%20format%20those%20cells%20to%20have%20a%20visual%20clue%20for%20dropdowns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20you%20have%20inserted%20the%20dropdown%20lists%20in%20few%20cells%20only%20and%20want%20the%20dropdown%20arrow%20to%20appear%20all%20the%20time%2C%20you%20may%20consider%20inserting%20the%20ComboBox%20from%20the%20Form%20Controls%20and%20specify%20the%20Input%20Range%20and%20the%20Linked%20Cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858876%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858876%22%20slang%3D%22en-US%22%3EThank%20you%20Subodh%20for%20your%20reply.%20Where%20do%20I%20find%20the%20combo%20box%20in%20form%20controls%3F%20Sorry....%20really%20novice%20to%20using%20drop%20downs.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858921%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858921%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410278%22%20target%3D%22_blank%22%3E%40Workinprogress%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThey%20can%20be%20inserted%20through%20Developer%20Tab%20and%20if%20you%20don't%20have%20Developer%20Tab%20on%20the%20ribbon%2C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fshow-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehere%20is%20how%20to%20show%20the%20Developer%20Tab%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20this%20is%20how%20you%20may%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D6OtHMdTCeoQ%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Einsert%20a%20ComboBox%3C%2FA%3E%20on%20the%20Sheet%20and%20set%20it's%20properties.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-858931%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-858931%22%20slang%3D%22en-US%22%3EThanks!%20That%20helped.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-859069%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20box%20indicator%20help%20for%20novice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F410278%22%20target%3D%22_blank%22%3E%40Workinprogress%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%3C%2FP%3E%3CP%3EPlease%20don't%20forget%20to%20choose%20the%20post%20which%20helped%20you%20to%20resolve%20your%20question%20as%20a%20Best%20Answer%2FResponse%20to%20mark%20your%20question%20as%20Solved.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Workinprogress
New Contributor
I am making some drop down boxes but the drop down box arrow is not there when I click on another box in the Excel sheet. How do I make it show all the time so people know there is a drop down box there? Sorry for such a novice question. I thought I had decent excel skills until I started to do this and now I feel like I need to take excel 101 again.
5 Replies

@Workinprogress 

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.

Thank you Subodh for your reply. Where do I find the combo box in form controls? Sorry.... really novice to using drop downs.

@Workinprogress 

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.

Thanks! That helped.

@Workinprogress 

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.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies