![how to insert a drop down calendar in excel 2016 how to insert a drop down calendar in excel 2016](https://media.gcflearnfree.org/content/563b9b9dca7fac0d9c7b3f7c_11_05_2015/getting_started_interface_start.png)
Right click on a worksheet cell and click on the Date Picker menu option to open the Date Picker. Ask a question and get support for our courses.
![how to insert a drop down calendar in excel 2016 how to insert a drop down calendar in excel 2016](https://wmfexcel.files.wordpress.com/2013/11/excel-tips-14-1-more-controls.png)
#How to insert a drop down calendar in excel 2016 64 Bit
Hey everyone, I have been looking online for the location of the date picker but all I have seen is that with 64 bit versions of excel. Select the calendar control and put on the “design mode.” Alternatively, drag a corner of the date picker (design mode on) to resize it. If you don't like the default date format, you can pick a different one in Excel, like February 2, or 2/2/ 1. i have office individual plan and would like to insert a decent calendar date picker, fast scrolling for years and months. Ctrl + double-click on a day to Insert the date only, using the default or existing date format.
![how to insert a drop down calendar in excel 2016 how to insert a drop down calendar in excel 2016](https://cdn.extendoffice.com/images/stories/doc-excel/doc-drop-down-calendar/doc-create-frop-down-calendar-0.png)
Double-click on a day to Insert the date and the formatting. Under "Controls," click "Insert" and then click "More Controls" under "ActiveX Controls." Select "Microsoft. Then, click the "Developer" tab in the ribbon menu. Popup Calendar Addin for Excel – ExcelFort Click the calendar icon to open the Date Picker dialog box, and then click a new date to replace the existing date in selected cell. In the Date/Time group, click the Insert Time button arrow to right The Calendar will drop down.ģ. Select a cell where you want to insert the current date.