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
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".
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").
Choose "Calendar Control" and press "OK".
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for