Communiquez avec les autres et partagez vos connaissances professionnelles

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

Suivre

How to add calender as "click to open" in excel cells ? Like google sheet's calender

user-image
Question ajoutée par Achu Suresan Sooraj , Sales & Marketing Executive , Accurate Meezan Trading LLC
Date de publication: 2015/11/21
Achu Suresan Sooraj
par Achu Suresan Sooraj , Sales & Marketing Executive , Accurate Meezan Trading LLC

Hi

 

Thanks for your reply.... But  in office no MS Date picker control..   Please suggest a way.

 

Utilisateur supprimé
par Utilisateur supprimé

 

Show Developer Tab in the Ribbon

Click the "Developer" tab, followed by the "Insert" menu. Select the "More Controls" button in the drop-down menu that appears.

 

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

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.

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

 

 

More Questions Like This