Create Dynamic Dropdown Lists in Excel

Поділитися
Вставка

КОМЕНТАРІ • 61

  • @jeevanbharadwaj5746
    @jeevanbharadwaj5746 2 роки тому +7

    As an trainee Engineer, I have come to realise that I sit in front of Excel and Word more than in the line or in the field. Your channel has been really helpful to me.
    Thank you!

  • @latifmoruf6720
    @latifmoruf6720 Рік тому +2

    Great videos ,few weeks ago ,I wanted to start learning excel, I downloaded a course but didn't understand jack ,found your videos last week and suddenly I feel like a pro 😀

  • @altrixa
    @altrixa 2 роки тому +8

    Thank you for all your work! Your videos are so clearly explained and easy to follow! Much appreciated! 🍀🙌🏼

  • @thomasedwardking7286
    @thomasedwardking7286 Рік тому +2

    This guy has saved me on so many occasions 🙏 He's that savvy dude you want to put your desk next to in the office and the guy you want to go bowling with every Friday night. Just the cleanest, simplest, and most accessible vids out there. The milestone is not surprising. But congratulations, mate 👍🏆

  • @2klatte
    @2klatte Рік тому +4

    Yes, please make that follow up data validation video. 🎉🎉 Congrats on surpassing the 1M milestone!

  • @alistairgene
    @alistairgene Рік тому +2

    Great tutorial! Very helpful. I'm wondering, is there a way to add a secondary dropdown list on a second column depending on what you choose on the drop down list on the first column? Like say on the first column you choose "comedy" from a drop down list, can you have the next column where you have another drop down list to choose what kind of comedy, like, say, "romantic," "slapstick," "musical," "action," etc.? But then if you choose "action" on the first list, the choices on the next column would be "adventure," "fantasy," or "sci fi?"
    Thanks in advance.

  • @marilynstephanienamukasa3729
    @marilynstephanienamukasa3729 3 місяці тому

    Thank you for the video, I have added entries to my table but they ain't reflecting in my drop down list automatically, what could be the reason for this cause i followed all instructions, I am also looking forward to the dependent drop down lists

  • @karenderuyter2568
    @karenderuyter2568 2 роки тому +2

    Thank you for making these fantastic video tutorials! EVERYTHING is getting a drop down menu starting now.😎

  • @purpleologist
    @purpleologist 2 роки тому +8

    Excellent video! I kept saying..."it needs to be a table!" And boom you made it a table. 😆 I like to keep the tables I make in alphabetical order. Looking forward to the dependent drop down list video! Thanks for all your hard work. And thank you for going at a pace that's so easy to follow. Congratulations on 1 million subscribers! 👏🏻

  • @Hopefully2025
    @Hopefully2025 2 роки тому +3

    Another awesome video! Please do make that follow-up video, I will be waiting for it :-)

  • @billperry2686
    @billperry2686 6 місяців тому

    Very helpful!!! Could you tell me if there is a way the dropdown list could show two columns but only insert one? Or, to only insert x number of characters from the dropdown list. Thanks, Bill

  • @arianneskelly4670
    @arianneskelly4670 2 роки тому

    This video really has helped me do my job more efficiently! Please make a dependent drop down list video.🙏🏼 Thank you so much!

  • @petrameyer1121
    @petrameyer1121 2 роки тому +2

    Do you have a video on how to create a timeline with Excel, please?

  • @malcomb111
    @malcomb111 2 роки тому +1

    Congrats on the gold play button! Huge accomplishment. Keep up the very helpful vids!

  • @alexisgt90
    @alexisgt90 11 місяців тому

    Thankyou for this video. I do have a question though. I actually am using excel to manage my finances and I wanted to learn hot to do the drop down list in order to just select the amount I have earned that monthsince its pretty consistent throughout the year. However...my earnings could be different from time to time because of quarterly incentives. How would I type that custom amount without being restricted due to the dropdown list?

  • @anna-kaydon32
    @anna-kaydon32 7 місяців тому

    That’s amazing❤ I have learned a lot since watching ur videos and continue learning ❤thank you

  • @leslietan8499
    @leslietan8499 2 місяці тому

    Hi, thank you for your video. Currently I'm facing an issue. After copying n paste the drop list to another work sheet, the copied drop list details are empty. R you able to advise me on this?

  • @BelenHerrero-qk7zr
    @BelenHerrero-qk7zr 7 місяців тому

    Thank you. It was super clear the explanation.

  • @joan-mariacbrooks
    @joan-mariacbrooks Рік тому

    You deserve that honor! I'm learning more from you than the class I'm taking.

  • @janetcheong2121
    @janetcheong2121 Рік тому

    I just subscribe.Thank you, looking forward to the multiple data validation. Do you have the video already?

  • @amrahabbasov5267
    @amrahabbasov5267 2 роки тому +1

    Thanks a bunch, sir for this awesome video! I have learned so much since I came across your channel.

  • @Ultinuc
    @Ultinuc Місяць тому

    Wish there was a way to choose multiple options from the dropdown

  • @cflorenzo5649
    @cflorenzo5649 2 роки тому +1

    I love all your excel videos , thanks 😊

  • @rogerwillis7692
    @rogerwillis7692 2 роки тому +3

    Please make that 2nd video!

  • @ama_kwame
    @ama_kwame Рік тому

    your videos have been so helpful. you're amazing, thank you.

  • @uchechukwualukwe1294
    @uchechukwualukwe1294 9 місяців тому +1

    Thanks a lot for all you do

  • @alaaabdelfattah773
    @alaaabdelfattah773 Рік тому +2

    thank you very helpful

  • @rolfmeier8469
    @rolfmeier8469 2 роки тому +1

    That's really amazing. Congratulation for your impressive success. There is no other chanel where we can find and follow the professional quality of your teaching. Go on! I am looking forward to following every of your episodes. Thanks a lot.

  • @omarelafia1175
    @omarelafia1175 2 роки тому +1

    thanks well explained, keep posting

  • @Patricia-mx7ml
    @Patricia-mx7ml 3 місяці тому

    Will you please help with this? How can I add a dropdown list within a dropdown list that has the next consecutive number in Excel? I'm trying to make an inventory number list like this: The first dropdown list will have the category of the item. When the category is selected, another dropdown will open, showing the next number available for that particular category.

  • @aicx40
    @aicx40 2 роки тому +1

    Thanks for sharing. Awesome.

  • @hamisindingo
    @hamisindingo Рік тому

    Can you create a video about how to add page numbers including separate Numeric and Roman numbers

  • @BrianAz
    @BrianAz 10 місяців тому

    I am using a dynamic dropdown list for the categories as I have far too many things I am tracking. In Data Validation I tried to input 40 different categories but it gave me an error that I exceeded the 255 character limit. So I created a dynamic dropdown list on a second sheet, but it does not work the same way as you demonstrated with the use of the Data Validation lists. Anything you can point me to as I really am struggling.

  • @jayc.5682
    @jayc.5682 2 роки тому +1

    Thank you so much!

  • @vickipedia3253
    @vickipedia3253 5 місяців тому

    Awesome 👏🏻 this video helped me so much

  • @deco3190
    @deco3190 Рік тому +1

    Very helpful videos

  • @EastCoastEDC
    @EastCoastEDC 7 місяців тому

    When I add a name to the bottom of the table I created it isn't automatically showing up in the drop down data validation list?

  • @monah2030
    @monah2030 2 роки тому +1

    Excellent as always !😀

  • @neekola1
    @neekola1 2 роки тому

    Thankyou! Would love to see more.

  • @LongNguyen-qj4rg
    @LongNguyen-qj4rg Рік тому

    that is great and easy to catchup, thank!

  • @donaldcunningham7545
    @donaldcunningham7545 11 місяців тому

    Excellent video

  • @tomrowe5826
    @tomrowe5826 2 роки тому +2

    Why not select the header for a given column and thereby apply these codes to the entire range all at once?

    • @meganthompson7207
      @meganthompson7207 2 роки тому

      I think it is because it also affects the title (if you have one) of the column.?

  • @anandpaul1113
    @anandpaul1113 2 роки тому +1

    Thank you

  • @mutasim4433
    @mutasim4433 2 роки тому

    Really amazing 👏👍, thanks a lot

  • @meganthompson7207
    @meganthompson7207 2 роки тому +1

    Oh my goodness, when little buddy at the end said "For passing one thousand hundred subscribers" I was just like "Yeah buddy, totally! That is 100% what that says!" Then I realized it was one million 😅I was just thinking how smart he was🤣

  • @dramina2326
    @dramina2326 2 роки тому

    Thanks so much.

  • @patmang4884
    @patmang4884 2 місяці тому

    Thanks!

  • @bahsaddigu9726
    @bahsaddigu9726 Рік тому

    thanks

  • @rodrigoborges8150
    @rodrigoborges8150 4 місяці тому +1

    Thumbs-up

  • @mlfoons9571
    @mlfoons9571 25 днів тому

    for passing 1 thousand hundred subscribers

  • @WarLockComics
    @WarLockComics 2 роки тому

    Awesome

  • @MrHonomag
    @MrHonomag Рік тому

    2:35 динамический
    5:47 динамический настоящий

  • @jifi-0178
    @jifi-0178 2 роки тому

    "...One thousand hundred subscribers" just for you. 😛

  • @raheem201231
    @raheem201231 Рік тому

    ‘1,000 hundreds subscribers’ 😂😂😂 congratulations

  • @rogerwillis7692
    @rogerwillis7692 Рік тому

    The movie"Elf" as a Horror genre. 🤔😂😂😂😂😂

  • @Salaaredit12
    @Salaaredit12 2 роки тому +1

    First

  • @andiv5118
    @andiv5118 Рік тому

    not dynamic

  • @danielcivil9967
    @danielcivil9967 3 місяці тому

    Thank you very much

  • @ronalddcunha6136
    @ronalddcunha6136 5 місяців тому

    Thank you