How to Add a Drop Down Calendar in Excel 2007

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:
Moderately Easy

Other People Are Reading


  1. 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".

  2. 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").

  3. 3

    Choose "Calendar Control" and press "OK".

  4. 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 and warnings

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

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.