How to Add a Drop Down Calendar in Excel 2007

By Stephanie Ellen

Microsoft Excel 2007 is a spreadsheet application that enables easy data manipulation and sorting. Excel uses a user-friendly toolbar that has visual cues and easy-to-read buttons. It's a straightforward process to insert a drop down calendar that can display the year, month, and date in any chosen cell.

Step 1

Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the "Office" button at the top left, then choose "Excel Options". This will bring up a pop up window. Put a check mark in the "Show Developer Tab in the Ribbon" option, then click "OK".

Step 2

Click on the "Developer" tab. Click on the small arrow below the "Insert" tab and choose "ActiveX Controls". Click the last icon in the list ("More controls").

Step 3

Choose "Calendar Control" and press "OK".

Step 4

Click on a cell in your worksheet where you would like to place the calendar. Click the "Design Mode" button to turn off design mode and return to normal operation.

Tips & Warnings

  • If you don't see the calendar control, you made need to download the Active X control. See resources for a link.