Insert Drop Down Calendar In Excel 2016

Click insert from developer tab please see how to bring developer tab to ribbon.

Insert drop down calendar in excel 2016. And let s see the detailed steps below. In the more control dialog box select microsoft date and time picker control 6 0 sp6 and then click the ok button. Go to the developer tab controls group click insert and then click the more controls button under activex controls.

To insert it in your sheet just do the following. 1 click file tab and select options menu and the excel options dialog will open. A drop down calendar in excel is technically called microsoft date and time picker control.

Select microsoft date and time picker control 6 0 sp6 from the list. Then draw the drop down list to the worksheet where you want it to appear and resize the box with dragging its corner. Create drop down calendar.

Select more controls from the insert list. Right click the drop down list and click properties from the list. In the properties dialog box enter a specific cell in the linkedcell box and then close the dialog box.

Select the cell that needs a drop down list for data validation cell b2 in this example. Create a column or a row of the items in the active spreadsheet for the drop down list. If you want to insert a drop down list calendar in your current worksheet you need to enable developer tab in ribbon and then insert data and time picker control into the worksheet.