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. 1

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

  2. 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. 3

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

  4. 4

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

  5. 5

    Click "Settings."

  6. 6

    Select "List" in the "Allow" group.

  7. 7

    Type "Dates" in the source box. This makes your list these days.

  8. 8

    Check "In-cell drop-down" check-box.

  9. 9

    Click "OK."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.