Create a Drop Down Menu with Data Validation in Microsoft Excel

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ • 24

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

    Thank you for this quick, clear, and useful tutorial!

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

    Wow amazing tmmrw is my review test ict practical this is helpful

  • @indianinnj1
    @indianinnj1 14 років тому

    Thanks this really worked for me, however the shortcuts didn't. will try to figure this out later but for now it worked gr8

  • @leeleej08
    @leeleej08 15 років тому

    Just What I Needed.. Thanks!!

  • @Slipstream0001
    @Slipstream0001 14 років тому

    Hey buddy, very helpful. I have a question if you have time to answer; I've made a drop down list and now I want to make it so that when I choose something from the drop down list (1 of 6 items) it changes the value of about 5 cells in a column to 1 of 5 different combinations of numbers on sheet 2. You've probably already made a video about this but I'm not sure what the technical title/name would be. Thanks very much.

  • @tirathmistry
    @tirathmistry 16 років тому

    Awesome tutorial ExcelisHell
    Thanks so much for your awesome& useful tutorial
    God Bless:-)

  • @TeachExcel
    @TeachExcel  14 років тому

    @Slipstream0001 I don't have a video tutorial up about this b/c it's too specific of a topic. This could be done with some hefty formulas depending on what needs to be displayed or a macro. Private message me on here and we can work something out.

  • @TitanLV
    @TitanLV 15 років тому

    Good work! Its helped me! thx!

  • @jagiter
    @jagiter 14 років тому

    thanks so much. it really worked, at first i typed in the selection as two words n it didnt let me.

  • @MrThurack
    @MrThurack 11 років тому

    it's great ! Sir..... thank u for help!

  • @jayeshm.7580
    @jayeshm.7580 4 роки тому +1

    Thanks buudaa

  • @patrickthom4198
    @patrickthom4198 11 років тому

    I have a dependent list on an invoice. Right now I can select the type of product, and then from another list select the correct product code. The second list obviously contains selections according to what is selected in the first. Now, what I want to be able to do is select the correct product code from the second drop down list, and as I select that code, have it's price appear in another separate cell. is there a quick way to make that happen without having to create tons of lists?

  • @mohamedfawzy8441
    @mohamedfawzy8441 9 років тому

    many thanks to you

  • @shreeaasrivastava4467
    @shreeaasrivastava4467 11 років тому

    thank u so mch sir..
    i have learnt one more thing in excle... :)

  • @TrishTruitt
    @TrishTruitt 7 років тому

    Thank you!!

  • @joyrichert3873
    @joyrichert3873 10 років тому

    THANK YOU!!!!!!!!!!!

  • @aski2781
    @aski2781 7 років тому

    thanks for sharin!

  • @Leo27097
    @Leo27097 7 років тому

    Thanks you so much

  • @mongmong188
    @mongmong188 5 років тому

    Wew thank you somuch . . .

  • @MrsLougik
    @MrsLougik 8 років тому

    Shortcuts shown in video don't work on my computer, CTRL+F3 and F3 - is Brighness. What's wrong with my shortcuts?

    • @markmarogil2228
      @markmarogil2228 8 років тому

      +Luigik S You might be on a laptop which has "Fn" (function) keys enabled instead of the F-keys. You would then need to also hold down the Fn button, or go into your laptop setting to enable F-keys *before* Function keys,.

  • @Fury-Murali
    @Fury-Murali 6 років тому

    Thank U.......

  • @mohamedalimetwaly9162
    @mohamedalimetwaly9162 10 років тому

    Nice but how can make it numbers and do operations on it