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

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

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.


arrow blue right bubble This is just one of 120 powerful features of Kutools for Excel

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



btn read more     btn download     btn purchase

Add comment


Security code
Refresh