Create Dynamic Dropdown Lists in Excel

Тәжірибелік нұсқаулар және стиль

Learn how to create Excel dropdown lists that update and change based upon the contents of a range of cells that you specify. You'll learn all the important dropdown list skills in this video. ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/exceldropdownlists #excel #exceltutorials #microsoft365 #DubbedWithAloud
Aprenda a crear listas desplegables de Excel que se actualicen y cambien según el contenido de un rango de celdas que especifique. Aprenderá todas las habilidades importantes de la lista desplegable en este video. ***Tecnología de soporte para profesores y estudiantes en Patreon***: / technologyforteachersa... Aquí está mi lista de reproducción completa de tutoriales de Excel: bit.ly/tech4excel Considere decir "Gracias" haciendo clic el botón Gracias debajo del video. Aquí hay un enlace al archivo de práctica para este video: bit.ly/exceldropdownlists
Saiba como criar listas suspensas do Excel que são atualizadas e alteradas com base no conteúdo de um intervalo de células que você especifica. Você aprenderá todas as habilidades importantes da lista suspensa neste vídeo. ***Tecnologia de suporte para professores e alunos no Patreon***: / technologyforteachersa... Aqui está minha playlist completa de tutoriais do Excel: bit.ly/tech4excel Considere dizer "Obrigado" clicando o botão Obrigado abaixo do vídeo. Aqui está um link para o arquivo de prática para este vídeo: bit.ly/begintoexcel #excel #exceltutorials #microsoft365
English
This video has been dubbed using an artificial voice via aloud.area120.google.com to increase accessibility. You can change the audio track language in the Settings menu.
Spanish
Este video ha sido doblado al español con voz artificial con aloud.area120.google.com para aumentar la accesibilidad. Puede cambiar el idioma de la pista de audio en el menú Configuración.
Portuguese
Este vídeo foi dublado para o português usando uma voz artificial via aloud.area120.google.com para melhorar sua acessibilidade. Você pode alterar o idioma do áudio no menu Configurações.

Пікірлер: 53

  • @thomasedwardking7286
    @thomasedwardking7286 Жыл бұрын

    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 👍🏆

  • @altrixa
    @altrixa Жыл бұрын

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

  • @2klatte
    @2klatte Жыл бұрын

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

  • @jeevanbharadwaj5746
    @jeevanbharadwaj5746 Жыл бұрын

    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!

  • @malcomb111
    @malcomb111 Жыл бұрын

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

  • @karenderuyter2568
    @karenderuyter2568 Жыл бұрын

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

  • @joan-mariacbrooks
    @joan-mariacbrooks Жыл бұрын

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

  • @latifmoruf6720
    @latifmoruf6720 Жыл бұрын

    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 😀

  • @cflorenzo5649
    @cflorenzo5649 Жыл бұрын

    I love all your excel videos , thanks 😊

  • @omarelafia1175
    @omarelafia1175 Жыл бұрын

    thanks well explained, keep posting

  • @uchechukwualukwe1294
    @uchechukwualukwe12945 ай бұрын

    Thanks a lot for all you do

  • @alaaabdelfattah773
    @alaaabdelfattah773 Жыл бұрын

    thank you very helpful

  • @Hopefully2025
    @Hopefully2025 Жыл бұрын

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

  • @jayc.5682
    @jayc.5682 Жыл бұрын

    Thank you so much!

  • @rolfmeier8469
    @rolfmeier8469 Жыл бұрын

    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.

  • @anna-kaydon32
    @anna-kaydon323 ай бұрын

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

  • @BelenHerrero-qk7zr
    @BelenHerrero-qk7zr3 ай бұрын

    Thank you. It was super clear the explanation.

  • @monah2030
    @monah2030 Жыл бұрын

    Excellent as always !😀

  • @ronalddcunha6136
    @ronalddcunha6136Ай бұрын

    Thank you

  • @aicx40
    @aicx40 Жыл бұрын

    Thanks for sharing. Awesome.

  • @rogerwillis7692
    @rogerwillis7692 Жыл бұрын

    Please make that 2nd video!

  • @amrahabbasov5267
    @amrahabbasov5267 Жыл бұрын

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

  • @arianneskelly4670
    @arianneskelly4670 Жыл бұрын

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

  • @vickipedia3253
    @vickipedia3253Ай бұрын

    Awesome 👏🏻 this video helped me so much

  • @ama_kwame
    @ama_kwame Жыл бұрын

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

  • @deco3190
    @deco3190 Жыл бұрын

    Very helpful videos

  • @donaldcunningham7545
    @donaldcunningham75457 ай бұрын

    Excellent video

  • @LongNguyen-qj4rg
    @LongNguyen-qj4rg11 ай бұрын

    that is great and easy to catchup, thank!

  • @neekola1
    @neekola1 Жыл бұрын

    Thankyou! Would love to see more.

  • @mutasim4433
    @mutasim4433 Жыл бұрын

    Really amazing 👏👍, thanks a lot

  • @purpleologist
    @purpleologist Жыл бұрын

    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! 👏🏻

  • @rodrigoborges8150
    @rodrigoborges815022 күн бұрын

    Thumbs-up

  • @petrameyer1121
    @petrameyer1121 Жыл бұрын

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

  • @dramina2326
    @dramina2326 Жыл бұрын

    Thanks so much.

  • @meganthompson7207
    @meganthompson7207 Жыл бұрын

    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🤣

  • @alistairgene
    @alistairgene10 ай бұрын

    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.

  • @billperry2686
    @billperry26862 ай бұрын

    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

  • @bahsaddigu9726
    @bahsaddigu9726 Жыл бұрын

    thanks

  • @janetcheong2121
    @janetcheong2121 Жыл бұрын

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

  • @WarLockComics
    @WarLockComics Жыл бұрын

    Awesome

  • @alexisgt90
    @alexisgt906 ай бұрын

    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?

  • @BrianAz
    @BrianAz6 ай бұрын

    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.

  • @EastCoastEDC
    @EastCoastEDC3 ай бұрын

    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?

  • @hamisindingo
    @hamisindingo Жыл бұрын

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

  • @tomrowe5826
    @tomrowe5826 Жыл бұрын

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

  • @meganthompson7207

    @meganthompson7207

    Жыл бұрын

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

  • @jifi-0178
    @jifi-0178 Жыл бұрын

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

  • @Salaaredit12
    @Salaaredit12 Жыл бұрын

    First

  • @rogerwillis7692
    @rogerwillis76928 ай бұрын

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

  • @MrHonomag
    @MrHonomag Жыл бұрын

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

  • @raheem201231
    @raheem20123110 ай бұрын

    ‘1,000 hundreds subscribers’ 😂😂😂 congratulations

  • @andiv5118
    @andiv5118 Жыл бұрын

    not dynamic

  • @anandpaul1113
    @anandpaul1113 Жыл бұрын

    Thank you

Келесі