Use a Pre-designed Calendar Template in Excel Create an automatic Calendar ... It will ask you to enter the month and year to create a calendar. Enter accordingly and click on the OK button.