How do I get the date and time picker control 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 calendar drop down in Excel 2010?
Create a drop down list calendar in Excel
- Firstly, if you cannot see the Developer tab in the ribbon, you need to show it as follows.
- Then click Developer > Insert > More Controls.
- In the More Control dialog box, select Microsoft Date and Time Picker Control 6.0 (SP6) and then click the OK button.
How do I get the date and time picker in Excel?
Click the Data tab. In the Data type box, click Date and Time (dateTime). Click Format. In the Date and Time Format dialog box, in the Display the time like this list, click the option that you want, and then click OK.
How do I insert a drop-down calendar in Excel?
A drop-down calendar in Excel is technically called Microsoft Date and Time Picker Control. To insert it in your sheet, just do the following: Go to the Developer tab > Controls group, click Insert, and then click the More Controls button under ActiveX Controls.
How do you add a drop-down menu in Excel?
Create a drop-down list
- Select the cells that you want to contain the lists.
- On the ribbon, click DATA > Data Validation.
- In the dialog, set Allow to List.
- Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.
Can you insert a calendar into Excel?
On the File menu, select Close and Return to Microsoft Excel. Select the Sheet1 tab. On the Tools menu, point to Macro, and then select Macros. Select CalendarMaker, and then select Run to create the calendar.