

Well, the Excel drop-down calendar is technically known as Microsoft Date and Time Picker Control. In the appearing main tab list check the Developer box option and then click the OK button.Īlso Read: How to Create a Flowchart in Excel? (Step-By-Step Guide) Now from customizing the ribbon section, you have to select the Main Tabs.

On the Excel ribbon, you have to make a right-click, and after that choose the option Customize the Ribbon….Though this Excel Developer tab is kept hidden you can enable its visibility. Enable The Developer Tab on Excel ribbon.Įxcel date picker control actually belongs to the ActiveX controls family, which comes under the Developer tab.Note: Date Picker control of Microsoft works Microsoft’s very smoothly in the Excel 32-bit versions but not in Excel 64-bit version.
