Insert Drop Down Calendar In Excel
To insert it in your sheet just do the following.
Insert drop down calendar in excel. Select more controls from the insert list. 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.
In the excel options dialog box click popular in the right bar then check the show developer tab in the ribbon box and finally click the ok button. If you are using excel 2007 click office button excel options. The drop down calendar can significantly minimize the data entry errors for dates.
Go to the developer tab controls group click insert and then click the more controls button under activex controls. If you don t see the developer tab this is likely due to the fact that you need to customize your project workspace.