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

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

متابعة

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
تم إضافة السؤال من قبل Kashif Iqbal , Finance Officer , Foundation Wind Energy I Limited & Foundation Wind Energy II (Private) Limited
تاريخ النشر: 2014/07/13
LOURDES FEDILLAGA
من قبل 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.

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

JAWAD KHAN
من قبل 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
من قبل 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
من قبل 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. 

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

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟