Register now or log in to join your professional community.
if you want to select a date from a calender in MS Excel just as you can do in systray of your computer, how you can insert it?
Click the "Office" button and select the "Excel Options" option from the drop-down menu that appears.
Step2Click the "Popular" tab in the "Options" menu and place a check mark next to the "Show Developer Tab in the Ribbon" option. Click "OK" to save the changes.
Step3
Click the "Developer" tab, followed by the "Insert" menu. Select the "More Controls" button in the drop-down menu that appears.
Step4Highlight the "Microsoft Date and Time Picker Control" option, then click "OK."
Step5Click on the upper left corner of the cell to which you want to add the calendar and drag your mouse pointer to the cell's bottom-right corner. This will draw a rectangle around the cell.
Step6Release your mouse button to insert the calendar into the cell. Whenever you click on the cell, the calendar drop-down menu will appear.
These Are The Worksheets I have Prepared. I am Sure These Will Help You
In Excel2013 > Developer Ribbon > More Control > There is not any option Microsoft Data and Time Picker
For calendar, use Add Ins, One have to use the calendar control from insert object.
Yes, choose Developer, Insert, More Controls, Microsoft Data and Time Picker Control6.0 (SP6) drag or click where you want it.
