ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Achu Suresan Sooraj , Sales & Marketing Executive , Accurate Meezan Trading LLC
تاريخ النشر: 2015/11/21
Achu Suresan Sooraj
من قبل 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.

 

مستخدم محذوف‎
من قبل مستخدم محذوف‎

 

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.

 

 

المزيد من الأسئلة المماثلة