create a drop down calendar in excel 2013

Click the “Collapse Dialog” button at the right end of the “Source:” text box to collapse the “Data Validation” dialog box to a single line.Select the “List” choice from the “Allow:” drop-down on the “Settings” tab to restrict data entry in the selected cells to a list of cell values shown in the worksheet.

In the “Data Validation” dialog box that opens there are three tabs: “Settings,” “Input Message,” and “Error Alert.” Click the “Settings” tab to set the range of allowable values for the selected cell or cells.

Click the “Data Validation” button shown in the “Data Tools” button group on the “Data” tab in the Ribbon.

Select the cells within which you want to create the drop down lists.

The list of values MUST be on the same worksheet as the drop down lists.

Type the list of values you want to use as the values within the drop-down list into the same worksheet within which you want to place the drop-down lists.

Instructions on How to Add a Drop Down List in Excel Then select the cells where you want to show the drop downs lists and use the “Data Validation” tool to provide the user with a drop down list in those cells from which they can select a choice from the initial list of values you entered. To learn how to add a drop down list to Excel, first type the list of values you want the drop down list to display into a column within the Excel worksheet. You accomplish this in Excel by using the “Data Validation” feature. In this lesson, you will learn how to add a drop down list in Excel within a worksheet. Overview of How to Add a Drop Down List in Excel

Create a drop down calendar in excel 2013