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.

Insert a monthly calendar

Insert a yearly calendar

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

Click Enterprise >> Worksheet Tools >> Perpetual Calendar, see screenshot:


arrow blue right bubble Insert a monthly calendar

Do as follow to insert a monthly calendar.

1. Click Enterprise > Worksheet Tools > Perpetual Calendar, it will display the Perpetual Calendar dialog box. See screenshot:

2. Select the month you want to create the calendar through the From and To drop-down list. See screenshot:

3. Click Create the monthly calendar is created in a new workbook, See screenshot:

4. You can click File > Save to save it.


arrow blue right bubble Insert a yearly calendar

With the function of Perpetual Calendar, insert a yearly calendar is also easy and quick.

1. Click Enterprise > Worksheet Tools > Perpetual Calendar. See screenshot:

2. Select January from the From drop-down list and December from the To drop-down list, See screenshot: (By default, it show the current year in the dialog, you also can select the year from the list.)

3. Click Create, the yearly calendar is created in a new workbook. See screenshot:

4. You can click File > Save to save it.


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 120 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase