How do I add a date to a drop down list in Excel?

Create the Data Validation Drop Down List

  1. On the data entry sheet, select B3, where the drop down list of dates will be added.
  2. On the Excel Ribbon, click the Data tab.
  3. Click Data Validation (click the upper section of the command)
  4. On the Settings tab of the data validation dialog box, from the Allow drop down, click List.

How do you add a clicking calendar to a cell in Excel?

You can follow these steps to help you insert a calendar in your Excel spreadsheet using a template method:

  1. Open Microsoft Excel.
  2. Choose a calendar.
  3. Preview your selected calendar.
  4. Press “Create”
  5. Edit your calendar.
  6. Go to the “File” menu.
  7. Select “Customize Ribbon”
  8. Click “Insert”

Why doesn’t Excel have a date picker?

The Microsoft date picker does not work on the 64-bit version of Excel. The drop-down calendar is inserted with the help of ActiveX Controls in the Controls group of the Developer tab. The Microsoft Date and Time Picker Control 6.0 (SP6) is selected in the “more controls” box to insert the drop-down calendar.

Where is Microsoft Date and Time Picker control?

If you have 32 bit Excel installation and you find that this control is missing, you will need to search for mscomct2. ocx in your C:\Windows directory. Copy it to C:\Windows\System32 or C:\Windows\System64 depending upon Windows is 32 or 64 bit.…

Can’t find date and time picker 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 open VBA in Excel 2013?

Select the DEVELOPER tab from the toolbar at the top of the screen. Then click on the Visual Basic option in the Code group. Now the Microsoft Visual Basic for Applications editor should appear and you can view your VBA code.

Where is Developer option in Excel?

How to Add the Developer Tab to the Excel Ribbon?

  1. Click on the File menu, and scroll to the Options menu.
  2. Click the Customize Ribbon option in the Excel Options window.
  3. The Developer tab will appear on the default tabs at the top of the Excel window.