Excel Forum



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.