Premium Course: https://www.teachexcel.com/premiumco...
More tutorials: https://www.teachexcel.com
Excel Forum: https://www.teachexcel.com/talk/micro...
Step by step guide to creating drop down menus in Excel. This Excel video tutorial shows you how to use data validation in Excel in order to make a drop down menu that displays from any cell within a worksheet. This is a great tutorial for anyone who is not familiar with data validation but who still needs to make a drop down menu in Excel.
The real benefit to using drop down menus in Excel is that you can make it easier for a user to enter the correct value into a cell. This works well when creating a user form from an Excel worksheet.
For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!