Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Create a Drop Down Menu with Data Validation in Microsoft Excel

The Excel video tutorial shows you how to create a drop-down list/menu in excel. You will learn how to make an 'in-cell' drop-down list/menu the contents for which come from a list on the same spreadsheet tab and also for list content which comes from a separate spreadsheet tab. This means that your list/menu can be populated from a list on a separate worksheet when you are using a named range.

This is a basic introduction to how to create a drop-down list in excel using data validation.
   Topics Covered
Create an In-Cell Drop-Down List in Excel
Populate the List/Menu from the same or a separate Worksheet
Data Validation
Named Range
   Difficulty:         Easy
   Video:               Yes

Got a Question? Ask it Here in the Forum.