Excel Create Dependent Drop Down List Tutorial

Рет қаралды 1,078,213

7 жыл бұрын

A Quick Excel Tutorial of Dependent Drop down list (The options in the DROP DOWN list changes based on the cell value)
🔶 Get Excel File at : bit.ly/34Nqblq 🔶
Products:
🔷 gumroad.com/teknisha 🔷
Recommended Gadgets/Products:
www.amazon.in/shop/teknisha
Check the below Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18

Пікірлер: 235

@TVSCDN 2 жыл бұрын

Thanks for your simple uncomplicated explanations... ❤️❤️❤️

@JP-hg5pi 3 жыл бұрын

Clear, simple and quick. Thank you very much! So much better than the microsoft instructions!

@TEKNISHA 3 жыл бұрын

Glad it helped!

@user-lh4ue9uj4i 2 жыл бұрын

Thanks for the Video. Also i want to ask you something in case that i have make an error with the selection of second list , how i could change the selection which created at first?

@thebaldguytv1340 2 жыл бұрын

great video! Direct to the point and very clear. Thank you!

@TEKNISHA 2 жыл бұрын

Glad that this Tutorial helped you

@larsonfredrick2470 2 жыл бұрын

Excellent ! Short & sweet and to the point.

@TEKNISHA 2 жыл бұрын

Thank you

@prakashsathyapriya 2 жыл бұрын

Crisp without unwanted stories. You rocks

@naboulsikhalid7763 4 жыл бұрын

Great video, I need this tutorial for a personal project. Thank you

@jayanaidu7667 2 жыл бұрын

Thanks for the video What if I have to chose only 3 options out of 5 in the drop down skipping a cell. Example 1 3 and 5 how do I do it

@3dpowercontracting445 2 жыл бұрын

Thank you for the this video. How can i put the color automatically once i choose particular type? 😊

@shrikrushnajadhav2621 Жыл бұрын

I was confused for not getting dependent dropdown correctly, and you just tell exact reason of removing $ from column and cell number. Thank you.

@mazharkhadri5408 Жыл бұрын

Thank you so much for demonstrating the simplest way of doing this. Much appreciated. Keep up the good work 👏.

@josephdiingmajok7521 2 жыл бұрын

Short but extremely helpful, thanks a lot.

@TEKNISHA 2 жыл бұрын

Glad that this helped you

@mohanlhamsaraj4053 2 жыл бұрын

Super quick explanation with systematic approach...

@josemiguel2611 10 ай бұрын

Straight to the point. thank you !

@JimmiSTRATMAN 4 жыл бұрын

Very good video, didn't beat around the bush but quick & easy with good instruction. thanks for sharing & will subscribe to your channel

@TEKNISHA 4 жыл бұрын

Thank you jim

@christianjr3760 Жыл бұрын

Thank you very much my brother, this is what I have wanted to know since a month ago. 🙏🏾🙏🏾🙏🏾

@mspraveen50 Жыл бұрын

Thanks you did it simple to explain. How to remove the blank in drop down? Instead of offset

@gabrielnogales4407 2 жыл бұрын

OMG greatest solution ever... just look the other solutions over there for this same problem... you couldnt be more efficient! u made my day :)

@TEKNISHA 2 жыл бұрын

Glad that this solution helped you. I have also made another version. You can check that too. kzfaq.info/get/bejne/rtaYatqj1rScgY0.html

@hvsmanian8948 2 жыл бұрын

I learnt from your KZfaq channel. Great. Good Teaching. This is the easy way.

@dadathelegend 6 жыл бұрын

Thanks Buddy the video is very much useful for my exam purpose

@sweetmac17 8 ай бұрын

After creating the table, can I delete the selections on the left where you highlighted yellow? Will it also delete thr selections if I delete them?

@SunshineTube87 Жыл бұрын

Very simple and easy that many people make it complex....Thank you!

@TEKNISHA Жыл бұрын

Glad it was helpful!

@alvinfren6790 5 жыл бұрын

thank you so much for your video & it does help me alot

@sudhakarjain1299 2 жыл бұрын

Very simple explanation. Useful to me.

@dyandraap 10 ай бұрын

easy to learn, thankyou Mr. Teknisha~

@kianasteph_ 2 жыл бұрын

Thank you so much! It was exactly what I need it.

@TEKNISHA 2 жыл бұрын

Glad that you liked it

@bobbymartins7349 11 ай бұрын

Hi Nice Simple Vid but just to let u know I had issue going forward after removing both the $$ symbols, its only after I kept the 1st $ Symbol before ColumnG and removed the 2nd $symbol, i was able to proceed

@TValexTav 2 ай бұрын

Thank you, your information was very helpful, although I encountered some difficulties with titles containing multiple words (which I resolved by inserting underscores "_" between the words).

@juliayeo812 2 жыл бұрын

Thank you for the video! It definitely helped however I would like to know if I am able to select the 1st level and have the 2nd level automatically inserted on the 2nd level instead of having it as a drop down? Which means once I select the 1st level, I do not need to type out the 2nd level as I only have single text to display. 😊

@TEKNISHA 2 жыл бұрын

Glad that you liked it. Yes it is possible to pull the 2nd level text. For this you need to use a lookup method like index/match or vlookup. All your first level and respective 2nd level information needs to be in a table and then you can use a lookup method to populate the 2nd level based on the 1st level chosen

@juliayeo812 2 жыл бұрын

@@TEKNISHA oh no, I have not done those you mentioned before... I'm clueless! Can tou shed some advice here... thank you so much!!

@m.n.953 2 жыл бұрын

Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF). I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red. How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.

@chiragLakhmani 8 ай бұрын

TO THE POINT EXPLINATION , REALLY HELPFULL . TYSM

@sachinkishore4115 4 жыл бұрын

Thank you bro. It is working.

@mwendasilumesii9649 5 жыл бұрын

Wow!!! Sorted out like 90% of the problem I had, now the second column upon changing the first one.

@golddiamond6782 3 жыл бұрын

And finally it was the $ thing which was not allowing copying in the multiple cells.Thanks for sorting that out

@jintalaban119 2 ай бұрын

Thank you very much Sir, very well explained and uncomplicated...

@kch3019 4 жыл бұрын

Thanks for putting this up

@TEKNISHA 4 жыл бұрын

You are Welcome

@82chandar Жыл бұрын

Hi, Instead of dependent drop dow, can we get both fruit & vegetables in same list under names using expand & collapse. Eg: Fruit-> expand -> names & Vegetables -> names

@Temprelaxe11 5 жыл бұрын

Nice video, Good speed and time management. Crisp and clear...Thank you

@TEKNISHA 5 жыл бұрын

Thank you...

@eddieftw 3 жыл бұрын

Brilliant! Thank you.

@TEKNISHA 3 жыл бұрын

Glad that it helped

@krishankin8042 4 жыл бұрын

But in data validation we only e showing text not with his format which is used in data base? How can we use data validation with test als well as format ?

@jerrymilesmiles9313 2 жыл бұрын

Outstanding! Hi from Limón, Costa Rica!

@TEKNISHA 2 жыл бұрын

Glad that you liked it

@rishipradhan3633 3 жыл бұрын

Thank you Sir, video was really very helpful & easy to understand

@TEKNISHA 3 жыл бұрын

Glad it was of help

@thebmusproject 3 жыл бұрын

Nice one! Thanks!

@TEKNISHA 3 жыл бұрын

You bet!

@JamesJones-uk7zs 7 жыл бұрын

Nice video, but the method of adding blank cells to the range in case of additional values is sloppy and doesn't presentation t well. instead make the named range dynamic by using an OFFSET formula and COUNTA

@atulbharti7880 2 жыл бұрын

sir i have a lot of data in which i want dependent dropdown list.but first of all i have to maintain list category wise.which is very time consuming.Is there any way to separate list category wise.just like fruit,vegetable and so on.

@Nicecomputertutorial 9 күн бұрын

Excellent bro

@thebesttechnical3608 4 жыл бұрын

Supper explanation and very helpful

@sherko965 Жыл бұрын

amazing, excellent job

@remoteflying 3 жыл бұрын

Great video, other channels drag this on for 18 minutes. What if the first drop down had names with spaces? Like 'Green fruits" and "Orange fruits"? Named ranges cannot have spaces

@TEKNISHA 3 жыл бұрын

Thank you George. Check my updated video for the multiple dependent drop-down list. In this method you can use names with spaces. kzfaq.info/get/bejne/rtaYatqj1rScgY0.html

@paulbotha2002 Жыл бұрын

Can the data be on a seperate excel book from the dropdowns?

@rollingthunder4599 2 жыл бұрын

Liked your video, just what I was looking for.

@TEKNISHA 2 жыл бұрын

Glad that this Helped

@foodkpk5719 Жыл бұрын

Sooo nice my dear. very simple thank you so much. you are a nice teacherrrrr

@lakhbirsingh7009 2 жыл бұрын

Short & excellent

@m.mukhtiarali6063 Ай бұрын

it is so much easy. i really liked it.

@armieAHMAD Жыл бұрын

thank you so much.

@gloria770 6 ай бұрын

You are the best. Thank you.

@TEKNISHA 3 ай бұрын

Happy to help!

@CharlieChopstixTV Жыл бұрын

Very useful

@rinleak5712 Жыл бұрын

Thank you so so much for this video

@prabhaelliah3369 4 жыл бұрын

I want to know whether we can save a copy of the excel sheet content on the desktop

@TEKNISHA 4 жыл бұрын

I am not sure, what is your question exactly...

@RUNNAIFY 2 жыл бұрын

very quick and clear,tq Sir

@vickyvikneswari3956 2 жыл бұрын

Thank you! I managed to create the dependent list in excel :D

@TEKNISHA 2 жыл бұрын

Awesome. Happy that this helped

@surajitpradhan3032 Жыл бұрын

Thanks for it. It's working soo good.

@TEKNISHA Жыл бұрын

You are welcome

@TheGiorgioSol 9 ай бұрын

Very very good!

@intoqalbunahmad1731 3 жыл бұрын

I have a problem by doing the excel, menu scroll down menu and in the same time a name appear auto scroll up for the name that we chose in the other of the scroll down menu,

@Xandonezz 2 жыл бұрын

thank you! you solve my problem!

@TEKNISHA 2 жыл бұрын

Great. Glad that this helped

@chinnababu8673 Жыл бұрын

I watched many videos but this is great ...

@ankitpathak3695 2 жыл бұрын

Really thanks 👍🙏

@yashikayadav7149 2 жыл бұрын

What is the short cut key to use drop down list??

@manojvishwas6062 4 күн бұрын

thank you

@wamzfuna2452 2 жыл бұрын

I love this it is very applicable

@TEKNISHA 2 жыл бұрын

Happy that this helped you

@ouzz_zz 8 ай бұрын

thats a good yet not much a sufficent application. you could use the Indirect with Match, Char and CountA to set the range of the second combobox.

@LabTechNajmal Жыл бұрын

I am watching after 5 years of upload, thanks. It's useful

@hiren1980able 4 жыл бұрын

Thanks for sharing.

@TEKNISHA 4 жыл бұрын

Thanks for watching.. Hiren Patel

@afiartandcraft1219 16 күн бұрын

Thanks

@richardkwan2840 2 ай бұрын

Can you please searchable dropdown list that works for version 2019 or older

@Smw.9K Жыл бұрын

how to make condition if we change the type column it will automatically emptying the name column ?

@barbiebasnet7616 3 жыл бұрын

Sir can u make a video how to unlock file when 2 people save workbook at the same time

@pankajgupta9426 3 жыл бұрын

Very helpful 👍 🙂

@TEKNISHA 3 жыл бұрын

Glad that this was helpful

@prasannakatta4781 2 жыл бұрын

Sir can I use numbers as same way

@jayantmarathe9100 Жыл бұрын

Excellent👍👍👍

@TEKNISHA Жыл бұрын

thanks...

@anhnhatnguyet4628 2 жыл бұрын

A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?

@curlyrapunzel3380 Жыл бұрын

Yes, it can be done. You have to highlight the preferred column where you want the data validation to occur and apply the data validation in the column. E.g if you want the data validation to have effect in column D, you need to highlight the whole of column D and apply the data validation

@unitedworldcare9497 4 жыл бұрын

Thank you so much

@TEKNISHA 4 жыл бұрын

You are welcome

@malamala9881 2 жыл бұрын

Nice 😊👏👍teaching sir, tq for your support.

@abhijitraul940 Жыл бұрын

Thank you so much sir...

@martinstrnad6860 2 жыл бұрын

Question is how to do this in sharepoint excel file :d, cuz when you try to rename that "array"... it shows you msgbox you cant do it

@mohammedashrafak1900 Жыл бұрын

Perfect!

@shaik.khamer1475 2 жыл бұрын

Thanks Sir

@aleena_binoy3386 10 ай бұрын

Thank you❤

@arifkadir7456 10 ай бұрын

thanks

@techdunia6558 11 ай бұрын

Thankyou

@ristab5678 Жыл бұрын

❤thank you very much. 🎉

@iatfvijayan4360 Жыл бұрын

Thank

@intoqalbunahmad1731 3 жыл бұрын

Really need your help

@jaychikhalkar2351 2 жыл бұрын

Thanks sir u r great

@ramyarapolu9264 3 жыл бұрын

How to add this data validation on entire column excluding headers. My data changes very often.. could someone rply on this.

@rajanphadke9273 2 жыл бұрын

Thanks a lot

@TEKNISHA 2 жыл бұрын

Glad that this helped

@Islamiclibrary128 3 ай бұрын

Thanks...

@TEKNISHA 3 ай бұрын

You're welcome!

@sandeep142 2 жыл бұрын

Thank you so much...

@TEKNISHA 2 жыл бұрын

Glad that you liked it

@shakeeratadeoye6578 8 ай бұрын

Very easy to understand but I have a problem with the indirect function the other day I wanted to do it, it was saying there is a problem with the formula so I was thinking maybe it's the version of my Excel