Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Office Work Microsoft Excel Computer Science Computer Skills MS Office tools
user-image
Question added by Achu Suresan Sooraj , Sales & Marketing Executive , Accurate Meezan Trading LLC
Date Posted: 2015/11/21
Upvote (0) Views (5) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Achu Suresan Sooraj
by 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.

 

Deleted user

 

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.

 

 

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help