How to Add the Microsoft Date & Time Picker in Excel 2007
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.
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.
- Excel 2007 doesn't come with the Date and Time Picker by default.
- Download this free package to add its components to Excel.
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.
- Run the "mscomct2.bat" file.
- The "Excel Options" window will open.
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.
Ryan Menezes is a professional writer and blogger. He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association.