How to Create Dynamic Dependent Drop Down List in MS Excel

Sdílet
Vložit
  • čas přidán 25. 12. 2017
  • funcion y excel
    How to create dependent drop down list in MS Excel | This video will show how you can create dynamic and dependent drop down list in Microsoft Excel 2003, 2007, 2010, 2013, 2016. Using this list you can customize entries in your drop down list dependent on data in any cell or area.
    excel in hindi
    excel formula
    excel world
    excel sheet
    excel basics
    excel shortcuts
    excel
    excel tricks
    excel formulas
    excel academy
    excel android
    excel all shortcut keys
    excel balance sheet
    Excel b
    Excel Commands
    Excel Calendar
    Excel Data
    Excel Date
    Excel Exercise
    Excel English
    Excl Error
    Excel Functions
    Excel Filter
    Excel Fun
    Excel Gyan
    Excel Group
    Excel Hyperlink
    Excel is Fun
    Excel Online
    Excel Office
    dropdown in excel
    dropdown excel
    how to create drop down list in excel
    create dropdown in excel
    how to make a drop down list in excel
    drop down menu excel
    hide formulas in excel
    how to add drop down list in excel
    how to add drop down in excel
    create drop down in excel

Komentáře • 11

  • @sanjoyroy7490
    @sanjoyroy7490 Před 4 lety +1

    Excellent Sir. Your presentation is very attractive .

  • @monawarhossainchowdhury5089

    Thanks for the tutorial. its work nice. Keep it up......

    • @MicrosoftOfficeTutorials
      @MicrosoftOfficeTutorials  Před 4 lety

      Thanks a lot brother for your appreciation. ❤️ Such appreciation really help me to work better than before.

  • @meme32games95
    @meme32games95 Před 4 lety

    Very helpful

  • @kumarvarun12
    @kumarvarun12 Před 6 lety +1

    Thanks for uploading

  • @makeducationofficial
    @makeducationofficial Před 4 lety +1

    Very Good Explanation. Thank You. But what if, Departments are increased? For example if some "X" department added newly. It will be displayed in the drop down of DEPARTMENT. But what about the dependent list of X department? How it is created?

  • @yurifullerton2633
    @yurifullerton2633 Před 5 měsíci +1

    Sir would you be interested in doing some freelance work? Assisting with designing a detailed database? Do you have a website ppl can contact you through?

  • @SHEQXEL
    @SHEQXEL Před 3 lety

    Hi What if the dependent dropdown list is referencing numbers, unlike text or names as you have Accounts, Human Resource, etc. but rather product codes or SKU. I realized the dropdown becomes inactive. What is the solution?

  • @erfandaraby
    @erfandaraby Před 4 lety

    But it was not dynamic😑😑