labear.blogg.se - Excel date picker in cell 64 bit

You will see that a drop-down calendar control starts appearing on your Excel sheet:

Hit the cell, in which you have to enter the calendar control.

From the opened dialog box of More Controlsselect the Microsoft Date and Time Picker Control 6.0 (SP6).Now from the ActiveX Controls choose the “More Controls” button. Hit the Developer tab and then from the Controlsgroup, you have to make a tap over arrow sign present within the Insert tab.To apply this in the Excel sheet, perform the following steps: 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. From the opened window go to the right-hand side section.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.