For certain versions of Excel, such as Excel 2011 for Mac, you'll need to select 'New from Template' from the File menu instead of 'New.' Creating a calendar from a template will allow you to create a blank calendar that you can fill in with events. It will not convert any of your data into calendar format. Like this, we can create a calendar dates drop-down list. Things to Remember. Named range automatically takes the name from the selection based on the checkbox we tick. Drop down selection won’t be available but we can enter dates between provided dates only. Recommended Articles. This has been a guide to Calendar Drop Down in Excel. Create a Drop-down List Calendar in Excel 2007,2010,2013 When editing Excel, we usually need to add some date to the excel table to identify different work with different dates. Usually, we add those dates manually, but there is a way to select a date from a calendar so that we can save our hand from typing words or prevent wrong typing of date. We can open the drop-down calendar by clicking on the down arrow symbol. We need to click on any date in the calendar in the selected month to enter that date in the selected cell. We can change month to previous or next using the arrow button placed at the left and right side of the calendar. Follow the steps as shown in the below video. In the Developer tab - Controls group, click Insert, and then click the More Controls button under ActiveX Controls. In the More Controls window, find the Microsoft Date and Time Picker Control, select it, and click OK. Finally, click on a cell where you want to insert the drop down calendar.
1. Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). If it isn't, then click the 'Office' button at the top left, then choose 'Excel Options'. This will bring up a pop up window. Put a check mark in the 'Show Developer Tab in the Ribbon' option, then click 'OK'.2. Click on the 'Developer' tab. Click on the small arrow below the 'Insert' tab and choose 'ActiveX Controls'. Click the last icon in the list ('More controls').
3. Choose 'Calendar Control' and press 'OK'.
4. Click on a cell in your worksheet where you would like to place the calendar. Click the 'Design Mode' button to turn off design mode and return to normal operation.