How to add date drop down for cells in a column in Excel

Question

How to add date drop down for cells in a column in Excel

DJ 0

I am needing to find a way to add a drop down (or equivalent option) to a column of cells that will make it quicker to add dates than typing the date every time. I tried Add-Ins through the developer tab, but, after I install and open them, I don't see them anywhere. Maybe I just don't know how to access the Add-Ins. Please help. Thank you.

0 comments

1 answer

Your answer

Answer 1

Hi @DJ

Thank you for the detailed information. I tested a supported method that does not require an add-in. You can use Data Validation with a list of sequential dates to create a drop-down in the required cells.

Step 1: Create the date source list

Create a separate worksheet and name it DateList.
Enter your first date in cell A2.
Select the cell and drag the fill handle down to generate the required sequence of dates.
Include enough dates to cover the period you expect users to select.

Step 2: Apply the drop-down to the column

Return to the worksheet where dates need to be entered.
Select the required cells, for example B2:B500.
On the Data tab, select Data Validation.
On the Settings tab, set Allow to List.
In the Source box, select the date range created on the helper worksheet.
Ensure that In-cell dropdown is enabled, and then select OK.

When you select one of the configured cells, a drop-down arrow should appear and allow you to choose a date from the list. Microsoft documents this Data Validation process for Excel on Windows, macOS, and the web.

Please note that this produces a scrollable list of dates rather than a pop-up monthly calendar. It is nevertheless a supported option that does not depend on an add-in.

Regarding the add-in you installed, could you provide its exact name, your Excel version? Also, please check whether it appears under Home > Add-ins or Insert > My Add-ins. This information will help determine why the add-in is not currently visible.