Drop Down Calendar In Excel 2016

Go to the developer tab controls group click insert and then click the more controls button under activex controls.

Drop down calendar in excel 2016. On the data tab in the data tools group click data validation. The drop down calendar can significantly minimize the data entry errors for dates. Select the cell that needs a drop down list for data validation cell b2 in this example.

A drop down calendar in excel is technically called microsoft date and time picker control. In the properties dialog box enter a specific cell in the linkedcell box and then close the dialog box. In the more control dialog box select microsoft date and time picker control 6 0 sp6 and then click the ok button.

To insert it in your sheet just do the following. Click insert from developer tab please see how to bring developer tab to ribbon. Right click the drop down list and click properties from the list.