How do I insert a date picker in Excel 2010?

2010 and up: Click on File, click on Options, click the Add-ins tab. In the Manage drop-down, choose Excel Add-ins, and click Go. Use “Browse” to select the add-in and then click on OK. Verify that the Date Picker is checked in the add-in list and then click OK.

How do I insert a date picker in Excel?

Installing the Date Picker

1. Display the Developer tab of the ribbon.
2. Click the Insert tool.
3. In the ActiveX Controls section of the palette, click the More Controls option.
4. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool.
5. Click OK.

How do I insert a calendar drop down in Excel?

1: The easiest way

1. Select the cell to which you’re adding the validation control.
2. Click the Data tab.
3. In the Data Tools group, click Data Validation.
4. In the resulting dialog, choose Date from the Allow dropdown.
5. In the Start Date control, enter the first date in the period.

How do I insert a date picker in Excel 365?

If the Controls task pane is not visible, click More Controls on the Insert menu, or press ALT+I, C. Under Insert controls, click Date Picker. In the Date Picker Binding dialog box, select the field in which you want to store the date picker data, and then click OK.

How do I create a drop down calendar in Excel 2007?

Dropdown calendar in Excel

1. Go to File Tab (or Ribbon icon for Excel 2007)
2. Go to Customize Ribbon.
3. Check the “Develop” on the right under Main Tabs.
4. OK.
5. There you go.

How do I insert a calendar in Excel 2007?

Add Calendar Control to Worksheet Go to the “Developer” tab. Click Insert and choose “ActiveX Controls.” Click “More Controls” and select “Calendar Control” in the “More Controls” list. Click “OK.” Excel inserts a calendar control in “Design View,” which allows you to edit and customize the control.

How do I insert a Date Picker in Excel 365?

Under Insert controls, click Date Picker. In the Date Picker Binding dialog box, select the field in which you want to store the date picker data, and then click OK.