Create a Drop Down Menu with Data Validation in Microsoft Excel

Опубликовано: 06 Октябрь 2024
на канале: TeachExcel

164,431

395

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!