Forum Discussion
Michele_Warren
May 29, 2024Copper Contributor
Calendar Template
I have downloaded a calendar template for excel that I like. As I am creating new months for the calendar it stops in October 2024 from the dropdown tab. How do I create the other months of this year and for 2025, which are not listed in the dropdown tab on the excel sheet?
3 Replies
Sort By
- dscheikeyBronze Contributor
The dropdowns are created with the data validation or with macros. In the first case, go to the cell in the menu on data validation and look at the list or the formula that is there. If you get stuck, post the content here.
- Michele_WarrenCopper Contributor
This is what it shows me. I do not see where I can change a date validation. Am I looking in the wrong spot?
- dscheikeyBronze Contributor
Click in the cell with the dropdown. Not on the arrow.
In the Data menu, go to Data Validation.
There you will find the origin of the list that is displayed in the dropdown.
It could also be a formula.
Post the content here and you will be helped.