How to Add a Drop Down Calendar in Excel 2007

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.

Woman helping man with computer
credit: Jupiterimages/Pixland/Getty Images

Step

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

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

Choose "Calendar Control" and press "OK".

Step

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.