![]() Now click on Data Validation under the DATA tab.Įxcel Tips Ensuring data integrity by limiting date entry errors in a Microsoft Excel worksheet can easily be achieved by adding a calendar drop down list so that instead of entering dates manually you can rather select them from the list.Ī drop-down calendar in Excel is technically called Microsoft Date and Time Picker Control. Here is a New year gift to all our readers free 2013 Excel Calendar Template.ġ click File tab and select Options menu and the Excel Options dialog will open. To open the pop-up calendar users click the calendar icon. More free excel calendar templates are also available from the microsoft template gallery calendar section. There is an Outlook Date Control but I dont know what it does and it will not embed in Excel. In the Properties dialog box enter a specific cell in the LinkedCell box and then close the dialog you would find the date would be displayed in the specified cell. I am missing this control quite much since Im using it on my other machine Win 7 64 bit - Excel 2007 32 bit.Įnter dates from a calendar into active c. First select the cell where we need to create a drop-down list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |