CREATE DROP DOWN LISTS IN MICROSOFT EXCEL // Learn how to insert a drop-down list in Microsoft Excel. Drop-down lists allow users to select an option from a list you create. Also called drop-down box or drop-down menu, they can help make data entry easier and/or limit the allowable entries into a cell. This video will show you how to set up your drop-down menu list options as a table so that when edited, all drop-down menus get updated accordingly.
Add drop-down lists to cells in Excel for easier data entry
__________
FREE DOWNLOADS:
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
RESOURCES:
I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
__________
NOTE: Some links included here are affiliate links. If you click on these links and make a purchase, we may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
KEYWORDS: #ExcelTutorials, create drop-down list in excel, create drop-down menu in excel, create drop-down box in excel, create tables from lists in excel, create and manage drop-down lists, microsoft excel, Sharon Smith HR
__________
PLAYLISTS:
Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90
Excel Quickies (Under 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW
Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45
Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR