Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2023-10-25 13:30:11 | ![]() 3,378 Views |
In this tutorial let us see How to Create Multiple Dependent Drop Down Lists up to 3 levels in Excel.
For example, let’s say you’re dealing with Categories, Subcategories, and Items. Each in their respective columns, where I want to have the drop-down lists to be configured.
In this settings sheet, I have the list of categories and the Sub-categories which are dependent on Categories and then I have the list of Items which are further dependent on sub-categories. So, you have to arrage your data in this manner.
First what we need to do is naming the ranges for our convenience.
**Subscribe ️ https://bit.ly/3sPIZvD and Hit the Bell Icon** to stay updated with our latest videos! Don’t miss out on the fun, learning, and inspiration!
**Enjoyed the video? Give it a Thumbs Up!** It helps us a lot!
**About dptutorials:**
dptutorials is your go-to place for project management related tools like Oracle Primavera P6, Microsoft Project including necessary business skills/tools like Microsoft Office, through easy learning tutorials and thus making your work pleasurable and productive.Join our community for sharing valuable knowledge to the project management industry.
**Watch Next:**
Oracle Primavera Tutorials : https://bit.ly/3fn9PFH
Microsoft Excel Tutorials : https://bit.ly/2V5de5l
Microsoft Project Tutorials : https://bit.ly/37guNl7
**Affiliate Links:**
Support our channel by using our affiliate links for your online shopping:
1. Amazon [India] – https://amzn.to/3tqYzSO
2. Flipkart – http://fkrt.it/6SZEgVNNNN
️ **Visit Website:**
Check out our website www.dptutorials.com and show your support!
**Best Equipment & Tools for YouTube Channel** : ️ https://www.dptutorials.com/besttoolsforyoutubechannel
**Connect With Us:**
Follow us on [Social Media Platform] for behind-the-scenes, updates, and more!
YouTube: http://www.youtube.com/c/dptutorials
Instagram: https://www.instagram.com/dptutorials/
G+: http://ift.tt/2kAOpa6
Twitter: https://twitter.com/dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Websites: http://www.dptutorials.com &
http://www.askplanner.blogspot.com
Telegram: https://t.me/dptutorials16
**Business Inquiries:**
For collaborations and business inquiries, contact us at [email protected]
Thank you for your support! Let’s create, learn, and have fun together!
#dptutorials #primavera #primaverafree #exceltraining #exceltricks #exceltips #excelfreetraining #excelfreelearning
️Tags: –
excel formulas in english, excel in english, excel tutorial in english,ms excel in english,ms excel tutorial in english, learn excel in english,vlookup in excel in english, learn ms excel in english, excel training, excel tutorial, microsoft excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,microsoft excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in hindi, excel formulas and functions in hindi, excel tricks, excel in hindi, excel shortcut keys, excel vlookup, excel formulas in hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, excel sum formula, sum formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Please take the opportunity to connect and share this video with your friends and family if you find it useful.