![]() ![]() In the resulting dialog, choose Date from the Allow dropdown.In the Data Tools group, click Data Validation.Select the cell to which you’re adding the validation control. ![]() How do I create a date drop down list in Excel? Alternatively, use Excel to make a custom calendar. Scroll through the dialog box until you find the Microsoft Date and Time Picker tool.Įasiest way is to use the numerous pre-made calendar templates: Go to File > New > “calendar” in search field > select calendar > Create.In the ActiveX Controls section of the palette, click the More Controls option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |