How to Create a Drop

1. Click the 'Office' button, and then click 'New.' Click the 'Create' button on the dialog box to accept the default values for a new Excel workbook.
2. Click the 'Office' button again, and then click the 'Options' button. Click the 'Show developer tab' check box to display the tab containing the drop-down calendar control.
3. Click the 'Developer' tab, and then click the 'Insert' button of the 'Controls' panel. Excel will display a list of controls you can insert in your workbook. None of the displayed controls is a drop-down calendar, but Excel enables access to more controls than those shown.
4. Click the icon in the lower-right corner of the control gallery that appears, to run the 'More controls' command. Excel will display a dialog box that lists additional controls you can enter in your workbook.
5. Click the item labeled 'Microsoft date and time picker,' and then click 'OK' to insert the calendar in your worksheet.
6. Right-click the calendar, and then click 'Properties' to display a window allowing you to process the date that a user picks with the calendar control.
7. Type the reference for a spreadsheet cell in the row labeled 'Linked cell.' For example, type 'G4' to indicate cell G4 of the current worksheet. The calendar control will insert the date the user picks in this cell.
8. Click the 'Design mode' button of the 'Controls' panel to exit design mode and enter user-input mode.
9. Click the down arrow of the calendar control, and then click any date in the drop-down calendar that appears. The cell whose reference you entered in Step 7 will fill with the date you chose.