How to Add the Microsoft Date & Time Picker in Excel 2007

Written by ryan menezes
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Add the Microsoft Date & Time Picker in Excel 2007
The Date and Time Picker adds date boxes to spreadsheets. (number background image by kuhar from Fotolia.com)

Excel 2007 doesn't come with the Date and Time Picker by default. Microsoft bundles this ActiveX control in a package called Microsoft Windows Common Controls. Besides the Date and Time Picker, it includes controls to further handle dates and manage scrolling and animation.

Download this free package to add its components to Excel. To show the Date and Time Picker in Excel, you then have to enable the Developer tab, which stores several such controls.

Skill level:
Easy

Other People Are Reading

Things you need

  • Microsoft Excel 2007
  • Internet connection

Show MoreHide

Instructions

  1. 1

    Download Microsoft Windows Common Controls-2 6.0 from the Microsoft website.

  2. 2

    Extract the .cab file's contents. Newer Windows versions open .cab files directly. Older versions need extraction software such as WinZip or WinRAR.

  3. 3

    Run the "mscomct2.bat" file. This installs the Microsoft Date & Time Picker.

  4. 4

    In Excel, click the Office button on the screen's top left corner. Select "Excel Options." The "Excel Options" window will open.

  5. 5

    Click "Popular" from the top of the left column.

  6. 6

    Check the box next to "Show Developer tab in the Ribbon." Close the window. Excel's ribbon now contains the Developer tab to the far right.

  7. 7

    Click on the Developer tab to show its controls. Click the "Insert" button, and select the bottom right icon, which shows additional ActiveX controls. The "More Controls" window will open.

  8. 8

    Choose "Microsoft Date and Time Picker Control 6.0 (SP4)" and close the window. Your mouse cursor will turn into cross hairs.

  9. 9

    Click and drag anywhere on your spreadsheet to create a date box.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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