Summary
Keywords
Full Transcript
Create dependent drop down lists in Excel to select items based on another list selection. Drop-down lists are very common in the web world and you can also create it easily in Excel. In this video, I will show you how to create a dependent drop-down list in Excel (also known as a conditional drop-down list). What is a Dependent Drop-down List in Excel? While a drop down list allows you select an item from a list, a dependent drop-down list allows you to change the items in a drop down based on what you have already selected. Here is simple example. You have two drop down lists with the first one showing countries and the second one showing cities. cities dropdown indirectly depend on country dropdown. when You select the US from country list, and all the cities in the US appear in the adjacent drop down. And when you select India, all the cities in India appear. DATA VALIDATION DROPDOWN VIDEO SERIES: 1. how to create drop down list from another sheet in excel || Hindi | using data validation https://youtu.be/-IDqfwby5MM 2.Data Validation Auto Updating DropDown List In Excel Hindi || Dynamic DropDown List https://youtu.be/EX2ZahZ3pHo 3. How To Create Searchable Drop Down List In Excel || Hindi || HD https://youtu.be/HwVbH_x6nMk My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV #DependentDropdownList #Excel #ExcelTricks #DeepakEduWorld Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: POWERPOINT COURSE ► https://youtu.be/OekrBhNybP0 ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► https://youtu.be/m4KNkHwcV48 Subscribe Deepak EduWorld ► https://www.youtube.com/deepakeduworld Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld LinkedIn ► https://www.linkedin.com/in/deepakedu...
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
