How To Insert Calendar In Excel 2007 Drop Down Menu

If you are using excel 2007 click office button excel options.

How to insert calendar in excel 2007 drop down menu. Select microsoft date and time picker control 6 0 sp6 from the list. Inserting a calendar in excel will help you to resolve these problems. Now whenever we select any cell in the c column we can see a drop down calendar at the top right corner of the selected cell.

1 inserting calendar based on templates available in excel. You just need to insert a drop down calendar and select the date from there. Go to the developer tab controls group click insert and then click the more controls button under activex controls.

Insert a calendar control. Then click developer insert more controls. Then draw the drop down list calendar to the worksheet where you want it to appear and resize the box with dragging its corner.

In the more controls dialog just select microsoft date and time picker control 6 0 and then click the ok button. The drop down calendar can significantly minimize the data entry errors for dates. Right click the drop down list calendar and click properties from the list.

Then click developer insert more controls. We can open the drop down calendar by clicking on the down arrow symbol. A drop down calendar in excel is technically called microsoft date and time picker control.

If you are using excel 2007 click office button excel options. So you want to create a drop down calendar in excel. Steps to insert create calendar in excel.