Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to add Calender in drop down menu in MS Excel?

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?

user-image
Question ajoutée par Kashif Iqbal , Finance Officer , Foundation Wind Energy I Limited & Foundation Wind Energy II (Private) Limited
Date de publication: 2014/07/13
LOURDES FEDILLAGA
par LOURDES FEDILLAGA , Accounts Payable Analyst , JOCANIMA CORPORATION

We can insert it by following the Steps below: Step1

Click the "Office" button and select the "Excel Options" option from the drop-down menu that appears.

Step2

Click 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.

Step4

Highlight the "Microsoft Date and Time Picker Control" option, then click "OK."

Step5

Click 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.

Step6

Release your mouse button to insert the calendar into the cell. Whenever you click on the cell, the calendar drop-down menu will appear.

Utilisateur supprimé
par Utilisateur supprimé

These Are The Worksheets I have Prepared. I am Sure These Will Help You

JAWAD KHAN
par JAWAD KHAN , Manager Human Resources and Administration , Punjab Population Innovation Fund

In Excel2013 > Developer Ribbon > More Control > There is not any option Microsoft Data and Time Picker

Aranganathan Devarangam
par Aranganathan Devarangam , Associate Manager - Training (IB and Legal Processing Division - IDES Division) , IB and Legal Processing Division

For calendar, use Add Ins, One have to use the calendar control from insert object.

Dima Vernigora
par Dima Vernigora , Sales Asisstance , MARKS & SPENCER

Yes, choose Developer, Insert, More Controls, Microsoft Data and Time Picker Control6.0 (SP6) drag or click where you want it. 

More Questions Like This

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?