CREATING A DYNAMIC DROP DOWN LIST IN EXCEL: Office 365 & 2013 Version Made Easy!

Published: Apr 09, 2024 Duration: 00:04:39 Category: Education

Tags : insert worksheet microsoft excel spreadsheet microsoft office 365 Excel tutorial Excel tricks Excel tips excel 2013 data validation dynamic drop down list searchable drop down list dependent drop down list cell referencing columns excel training excel solutio excel made easy copy paste ctrl how to create a drop down list in excel excel data validation techniques advanced excel formulas advanced excel tricks excel data validation text length excelwith ugo

Trending searches: is office 365 down

Intro are you aware that using Microsoft Excel you can create a drop- down list that helps you insert your data without having to type it in manually come let me show you how it's done here I already have my source data where I'll be bringing in the information that I will be inserting inside my drop- down list so on the drop- down list in the space provided for Department I'll highlight the column using the Office 365 version I have the option to search I'll right click and on this box that has searched menu I'll type in data and click on validation then in this section I'll click and select list in the source option I'll go to my source data and highlight the entire department information press enter and click okay so in that space you can see that all the department information is already inserted in my drop down list so all I need to do is to click and select any Department that I want and in the gender section I will also highlight right click type in data click on validation go back and select list here I can as well type in my gender information I'll type male put a comma type in female click okay so all I need to do is to click select and insert is as simple as that using other version of excel that is not Office 365 like this particular version is Microsoft Excel 2013 version working with the same information I would come over my drop- down list and highlight the department column then when I right click you can see that I do not have the option to search like the first one so what I would do is to go to data tab then I will go to data validation click on data validation then I would change any value to list then to my source option I'll go to my source data and select the entire staff department click enter click okay but with this version you can see that the staff department was presented more than once according to the manner it was shown from the original Source data which was not the case when we used the Office 365 version so to address that what we will do is to go and remove duplicate values from the staff department because I don't want to tamper with this original data I would copy the staff department and paste it another column I would go to data tab click on remove duplicate and I'll select continue with Remove duplicates current selection click on remove duplicate yes we are working on column D and we click okay so we can see the number of duplicate values that were removed and unique values remaining now back to our drop- down list we would go back and select the column click on data and to data value validation we select data validation we'll click on list to the source we'll go and select our unique values press enter click okay now you can see that duplicate values have been removed and you can go and select any Department that is applicable to each staff and back to the gender option click on data validation then we select list the source can be typed in male comma female and click okay so here we have our gender information in the drop- down list I will just copy the formula down across other rows then we can select so this is how you create a drop- down list in Microsoft Excel using different versions of Microsoft Excel thank you for watching please don't forget to subscribe like and share this video bye for now

Share your thoughts

Related Transcripts

Microsoft Excel-𝐂𝐑𝐄𝐀𝐓𝐄 𝐃𝐘𝐍𝐀𝐌𝐈𝐂 𝐃𝐑𝐎𝐏 𝐃𝐎𝐖𝐍 𝐋𝐈𝐒𝐓 !! 𝐓𝐢𝐩-𝟎𝟔 | OFFICE 365 | CONTINUOUS LEARNING

Category: Education

[music] foreign [music] [applause] [music] you Read more

EXCEL 365 TRUCCHI: 👨‍🏫 La nuovissima funzione TRADUCI #m365insider #shorts

Category: Education

My life be like my be [music] like my life be [music] like my like sad please come my way leaving when i str sacrifice in the price life like a f like i'm on island by my stranded low key stand cand reflect on all the things i tr my hand at search for the equation persas i'm used to finding comfort... Read more

Microsoft Excel- 𝐃𝐲𝐧𝐚𝐦𝐢𝐜 𝐃𝐫𝐨𝐩 𝐃𝐨𝐰𝐧 𝐋𝐢𝐬𝐭 !! MICROSOFT OFFICE 365 | CONTINUOUS LEARNING

Category: Education

कि नमस्कार आदाब सत श्री अकाल आदाब वेलकम टू माय चैनल कंटीन्यूअस लर्निंग ए प्लेटफॉर्म व्हेयर विल नॉट वेदर एंड ब्रोट टुगेदर वे कैन वॉच वीडियोस विदाउट वेस्टिंग टाइम ओं है तो फ्रेंड्स आज इस वीडियो में हम एक्सल के एक कमाल की फीचर के बारे में बात करने वाले हैं जिस फीचर की यू को यूज करके मैं बनाऊंगा डिपेंड ड्रॉप डाउन लिस्ट अब आप सोच रहे होंगे कि ड्रॉप डाउन लिस्ट क्या होता है तो वह इस कुछ ऐसा होता है जिसे फॉर एग्जांपल मुझे डेट बनाना है जिसमें अगर एक कॉलम... Read more

How to Download & Install MS Excel 2024 | Install Excel Latest Version

Category: Science & Technology

Hi guys this is a quick and concise video on how to download and install microsoft xcel 2024 for free in windows 10 or windows 11 so without wasting more time let's install excel 2024 first let's check excel is already installed or not so as you can see excel is not installed on my system yet instead... Read more

How to create a drop-down list in Microsoft Excel

Category: Science & Technology

[music] Read more

Is it the BEST bowhunting setup? | It's definitely Top 10! | My 2024 Bowhunting Gear List

Category: Sports

Hi i'm ne with average jack garre pro shopping range here in fburg pa and today i want to go over my hunting setup from top to bottom for 2024 so if you're a regular viewer of the channel and you saw me back in april um and i want you you yes you the regular followers of the channel if you see me shooting... Read more

JI CHANG WOOK TERSENYUM SAAT AYU TING TING MELAKUKAN INI - SELEB ON NEWS

Category: Entertainment

[musik] bikin irim maksimal ayo tingting ketemu j [musik] changw ayo tingting lagi-lagi bikin geger dunia maya ya ibu satu anak itu bikin iri warganet gara-gara dapat menggandeng tangan j changwuk aktor asal korea selatan saat sedang syuting bareng lucunya pemeran drama backstreet roky hanya diam dan... Read more

Élections nationales de 2024 en Thuringe (FR)

Category: Education

Dans cette vidéo il est question du résultat des élections régionales de 2024 en turinge je t'explique le résultat des élections et ses conséquences en 2024 l'afd dirigé par bjorneck remporte l'élection régionale en turinge avec plus de 30 % des voix c'est la première fois qu'un parti d'extrême droite... Read more

Osttimor einfach und kurz erklärt

Category: Education

In diesem video geht es um osttimor ich erkläre dir wo ostimor liegt und was du sonst noch über das land wissen solltest osttimor liegt in südostasien und teilt die insel timor mit indonesien es hat eine fläche von etwa 15 000 quadratkilm die nordküste grenzt an die timorsee die südküste an die savusee... Read more

Excel - AutoComplete for Drop-down List - New Feature Coming to M365

Category: Education

Intro hello, i'm chris menard. excel keeps rolling out the great features for microsoft 365 users. regardless of the excel version you're on now, you can do an auto complete and you can do a dropdown list. if you don't know how to do those, i'm going to cover them in just a second. but microsoft... Read more

#shorts #excel #TallyERP9 #online #ExcelExcel , Microsoft Excel, Excel Tutorials, Education #ytshort

Category: Education

Oh Read more

Téléchargement, Installation et Activation Microsoft Office LTSC Professional Plus 2024

Category: Science & Technology

[musique] bonjour tout le monde et bienvenue dans club tutoriel informatique dans ce tutoriel là on va voir comment télécharger installer et activer office 2024 donc la première chose on va aller sur ce lienl que je va laisser exactement dans la description de la vidéo com vous allez voir installer... Read more