![free date picker for excel free date picker for excel](https://d13ot9o61jdzpp.cloudfront.net/images/date-picker-form.png)
If an error message dialog box pops up after closing Properties, click the “OK” option on that window. Step 15: Thereafter, close the Properties window. Step 14: Enter a cell reference you want to link the drop-down calendar within the LinkedCell box on the Properties window. Step 13: Right-click the inserted calendar drop-down control and select “Properties” on the context menu. Then drag it into an appropriate position on the sheet and resize its box as required. Step 12: Click anywhere within your spreadsheet to place the calendar drop-down control. Step 11: Press the “OK” button to confirm. Step 10: Select Microsoft Date and Time Picker Control 6.0 in the More Controls window shown directly below. Step 9: Then click the “More Controls” button on the ActiveX Controls options. Step 8: Click the “Insert” button on that tab. Step 5: Select the unchecked “Developer” checkbox. Step 4: Click Customize Ribbon on the left of the window. Step 3: Select “Options” on the left side of the tab to open the Excel Options window. Step 1: Open a spreadsheet you want to insert a date picker in within Excel.
#Free date picker for excel how to
This is how to insert a calendar in Excel with Microsoft Date and Time Picker Control 6.0 (SP6). The Microsoft Date and Time Picker Control 6.0 (SP6) control enables you to insert a drop-down calendar in Excel sheets. The Developer tab includes ActiveX controls you can select and add to sheets. As the Developer tab isn’t a default one in Excel, you’ll need to do some Ribbon customization for this method. Without add-ins, you’ll have to utilize Excel’s Developer tab to insert date pickers in sheets. Steps to Insert Drop Down Calendar (Date Picker) in Excel
![free date picker for excel free date picker for excel](https://images.squarespace-cdn.com/content/v1/50a09124e4b081ffff78dcb9/1449308123225-1LF401XIX5K44401PI07/2.jpg)
#Free date picker for excel free
![free date picker for excel free date picker for excel](https://cdn.ablebits.com/_img-blog/excel-calendar/ablebits-calendar-excel.png)
![free date picker for excel free date picker for excel](https://1.bp.blogspot.com/_3QrPv-CwOcc/Sz2Mybp42UI/AAAAAAAAAMY/2sMXvdXc_7I/s400/Date+Picker.png)
Excel is a Microsoft spreadsheet application that packs in many features.