Create a Dynamic Dropdown List




About this tutorial:

Video duration: 6:16
Check out my Blog:

How to create a dynamic drop down list in Excel. #exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

21 thoughts on “Create a Dynamic Dropdown List

    Katy A

    (July 29, 2018 - 3:21 pm)

    Very Very useful video but your swallowing just gave me cancer

    Scream for Me

    (July 29, 2018 - 3:21 pm)

    Thank you.

    DJ VJ

    (July 29, 2018 - 3:21 pm)

    May I have your email id please. I need some clarity on it

    ubaida aziz

    (July 29, 2018 - 3:21 pm)

    non work

    Karrie Cochran

    (July 29, 2018 - 3:21 pm)

    Hi! I'm trying to figure out how I can select multiple items from my drop down list (instead of just one item) and instead of filing in the cell with the full word, what goes into the cell is just the code. Example… Instead of Phone Conference and Face to Face Meeting, Phone conference would be PC and Face to Face Meeting would be FF.

    fadreen

    (July 29, 2018 - 3:21 pm)

    How to do for three categories If eg: Country (France is selected it will show city according to your video, because two category. what if i need third category where if i first select country france then it will show all the cities like paris, lyon etc then if i select paris it should show places in paris. how to do that??

    fadreen

    (July 29, 2018 - 3:21 pm)

    Hello the feature you have shown is for two option what if i have to choice three function like for eg: if i have select a city from it it has to select a hotel & when i select the hotel how will it select the country it is in. can you please help on this

    thesongmuse1

    (July 29, 2018 - 3:21 pm)

    Hi! I'm wondering if you have a tutorial for this using Microsoft Office Professional Plus 2010? This one is AMAZING! But, I seem to get lost (as in – some of the commands/steps don't work) when you get to the sub-categories and THAT is what I need to do for a project I am working on today.

    Mouafki Djamel Eddine

    (July 29, 2018 - 3:21 pm)

    Thanks a lot, very very very useful, but can i have i idea about changing colors when (indirect) command put ?
    Thanks again

    vivek chourasia

    (July 29, 2018 - 3:21 pm)

    It's nice & simple…thank you for sharing…looking for advance example of dropdown…please share😊😊😊

    bijan hajiamiri

    (July 29, 2018 - 3:21 pm)

    Thanks

    Haasan Nasser

    (July 29, 2018 - 3:21 pm)

    thanks

    Deva k

    (July 29, 2018 - 3:21 pm)

    how can i create same as user form in excel ?

    Sushant Mayekar

    (July 29, 2018 - 3:21 pm)

    Thank You so much .I learn so my different and new things in excel,as as new learner.

    Mark McKay

    (July 29, 2018 - 3:21 pm)

    Extremely informative. Thank you so much.

    manojiittm

    (July 29, 2018 - 3:21 pm)

    THANKYOU SO VERY MUCH.. IT WAS VERY HELPFULL

    Uniform Architects

    (July 29, 2018 - 3:21 pm)

    in the final step when you used Indirect how to make it depend on two cells ?
    example im making Three Cells
    1- Company Name > (company 1 , company 2 , company 3)
    2- Departments > ( HR, Management,Sales,Marketing)
    3-Company 1 > (HR employees) (Employee 1 , employee 2)
    Company 1 > (sales employees) (Employee 3 , employee 4)
    Company 2 > (HR employees) (Employee 5 , employee 6)
    Company 2 > (sales employees) (Employee 7 , employee 8)

    Ricky Anonsen

    (July 29, 2018 - 3:21 pm)

    you made it really complicated at 2:45

    J Do

    (July 29, 2018 - 3:21 pm)

    Great video, I am a shortcut user as well, and the video content is great and helped me alot. Thank you.

    Paramveer Singh

    (July 29, 2018 - 3:21 pm)

    When we select american and than GM both drop down have value.
    Now when again selecting Japanese, GM should be remove from second drop down. I tried but not able to do that. Can anyone help

    Amadou Idiguine Adamou

    (July 29, 2018 - 3:21 pm)

    Very usefull

Leave a Reply

Your email address will not be published. Required fields are marked *