Create a Drop Down Menu with Data Validation in Microsoft Excel
http://www.TeachMsOffice.com
This tutorial shows you how to create a drop down menu in excel. You will learn how to create a drop down menu whose contents comes from a list on the same tab or worksheet and also a drop down menu whose contents come from a list on a separate tab or worksheet in excel. This tutorial uses the data validation feature in excel as well as named ranges. This is a helpful introduction with tips on making drop-down menus in excel.
To get the spreadsheet used here of for more excel video tutorials, macros, tips and tricks, visit the website http://www.TeachMsOffice.com You can also visit the forum there if you have any questions.
Have a great day!
Watch video Create a Drop Down Menu with Data Validation in Microsoft Excel online without registration, duration hours minute second in high quality. This video was added by user TeachExcel 13 January 2009, don't forget to share it with your friends and acquaintances, it has been viewed on our site 164,431 once and liked it 395 people.