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.
Download Microsoft Windows Common Controls-2 6.0 from the Microsoft website.
Extract the .cab file's contents. Newer Windows versions open .cab files directly. Older versions need extraction software such as WinZip or WinRAR.
Run the "mscomct2.bat" file. This installs the Microsoft Date & Time Picker.
In Excel, click the Office button on the screen's top left corner. Select "Excel Options." The "Excel Options" window will open.
Click "Popular" from the top of the left column.
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.
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.
Choose "Microsoft Date and Time Picker Control 6.0 (SP4)" and close the window. Your mouse cursor will turn into cross hairs.
Click and drag anywhere on your spreadsheet to create a date box.
Things you need
- Microsoft Excel 2007
- Internet connection