How to Make a Drop-Down List to Choose a Date in Excel

Written by carter mcbride

Share

Tweet

Share

Email

Microsoft Excel is a spreadsheet program that allows you to create and manipulate data and formulas. One useful function is creating a drop-down list. When you create a drop-down list, whenever you click on the list, it drops down and displays all the information in the list. When it is not clicked on, you can set what the drop down list says. This is especially useful if you are using many dates.

Skill level:

Easy

Other People Are Reading

Instructions

1

Type the dates into Excel. Put each date in a separate cell.

2

Highlight the cells and then in the upper, left side of Excel, type "Dates" into the box that has the cell address in it.

3

Click on the cell in which you want the drop-down list.

4

Click on the "Data" tab, then click "Data Validation." A window will pop up.