Quickly insert a monthly or a yearly calendar in Excel
Sometimes, for some purpose, you may need to insert a monthly or yearly calendar in a workbook. You can use an Excel Calendar Templates to get it done. But with Perpetual Calendar of Kutools for Excel, you can quickly insert a monthly or a yearly calendar in a new workbook.
Click Enterprise >> Worksheet Tools >> Perpetual Calendar, see screenshot:
1. Insert a monthly calendar.
Open the Perpetual Calendar dialog box, it will display the current month date. Directly click Create button, a new monthly calendar will be created in a new workbook. See screenshot:
2. Insert a yearly calendar
(1.)When the perpetual calendar dialog box has been activated, click the spinner to 12, and adjust the current month date to January, 2012. See screenshot:
(2.) Click Create button to finish it.