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:

Usage:

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.

This is only one feature of Kutools for Excel

It includes more than 120 functions and tools for Excel 2013, 2010, 2007 and Office 365.