Quickly insert a monthly or a yearly calendar in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
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
How to apply the Perpetual Calendar utility
Click Kutools Plus >> Worksheet >> Perpetual Calendar, see screenshot:
Insert a monthly calendar
Do as follow to insert a monthly calendar.
1. Click Kutools Plus > Worksheet > Perpetual Calendar, it will display the Perpetual Calendar dialog box. See screenshot:
2. Select the months you want to create the calendar through the From and To drop-down list. See screenshot:
3. Click the Create button, then the monthly calendar is created in a new workbook, See screenshot:
Note: If you check the Include previous/next month box, the last few days of the previous month and the first few days of the next month will be added to each month of the calendar.
4. You can click File > Save to save it.
Insert a yearly calendar
With the function of Perpetual Calendar, insert a yearly calendar is also easy and quick.
1. Click Kutools Plus > Worksheet > 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 shows the current year in the dialog, you also can select the year from the list.)
Note: If you check the Include previous/next month box, the last few days of the previous month and the first few days of the next month will be added to each month of the calendar.
3. Click the Create button, then the yearly calendar is created in a new workbook. See screenshot:
4. You can click File > Save to save it.
Demo: Create Perpetual Calendar in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs ā no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010ā2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 ā 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
