You can improve your work efficiently by using a drop-down calendar for data collection. The drop-down calendar can significantly minimize the data entry errors for dates.
Step 1: Click 'Insert' from 'Developer' Tab (please see how to bring 'Developer' Tab to Ribbon);
Step 2: Select 'More Controls' from the 'Insert' list;
Step 3: Select 'Microsoft Date and Time Picker Control 6.0 (SP6)' from the list;
Step 4: Click 'OK' at the bottom. You will notice the mouse cursor is changed to a small black cross '+'. Draw a square or click anywhere in the worksheet, and a box with date will appear. At the same time, the EMBED formula will also show up in the formula bar.
Tuesday, March 22, 2011. How to Add a Drop Down Calendar in Excel 2007 1. Make sure the Developer tab is showing in the ribbon (the toolbar at the top of the page). Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data. Enter the list of values for your drop-down in a column. Make sure to enter each drop-down entry in a separate, consecutive cell in the same column. For example, if you want your drop-down list to include 'New York,' 'Boston,' and 'Los Angeles,' you can type 'New York' in cell A1, 'Boston' in cell A2, and 'Los Angeles' in cell A3. I've been directed here by the Greek Microsoft Answers Community about a problem that I'm facing in Excel 2016. The problem is that I want to insert a dropdown calendar in a cell.
Step 5: Drage the box to the place where you want to put, and resize it to fit the cell;
Step 6: Click 'Design Mode' from 'Developer' Tab to activate the drop-down calendar;
Step 7: Click the small triangle and you can pick the date from the calendar;
Step 8: Setup the drop-down calendar properties by clicking the 'Design Mode' and select the calendar box, then click the 'Properties';
Step 9: Here are things you can set up through the properties:
1. Box size: you can set up the exact size you need by setup the values of Height and Width;
2. MinDate: setup the MinDate so that no date is prior to that date;
3. MaxDate: setup the MaxDate so that no date is after that date;
How Do I Insert A Calendar Drop Down In Excel Mac
4. LinkedCell: link the drop-down calendar to a specific cell.