How to Insert a Monthly or a Yearly Calendar in Excel Office 365?
Tags: kutoolsexceltutorial, stepstoinsertmonthly, kutools
Published: 2020-10-16 11:59:20

---
title: How to Insert a Monthly or a Yearly Calendar in Excel Office 365?
published: true
date: 2020-10-16 11:38:13 UTC
tags: KutoolsExcelTutorial,StepstoInsertMonthly,Kutools
canonical_url: https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/
---

In this guide, we will describe the steps to **Insert a Monthly or a Yearly Calendar in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Insert a Monthly Calendar:

Do as below steps to Insert a Monthly Calendar in the Excel spreadsheet.

- On the **Kutools Plus Tab, select** the **Worksheet** option, **choose** the **Perpetual Calendar** option from the drop-down menu.

![Choose the Perpetual Calendar option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Perpetual-Calendar-option.png)<figcaption id="caption-attachment-15860">Choose the Perpetual Calendar option</figcaption>

- It will open the **Perpetual Calendar Dialog Box.**
- In that dialog box, you need to **select** the **month** you want to create a calendar using the **From** and **To** drop-down lists.

![Perpetual Calendar Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-19.png)<figcaption id="caption-attachment-15863">Perpetual Calendar Dialog Box</figcaption>

- Now, you need to **click** the **Create** button and the monthly calendar is created in the new workbook.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-33.png)<figcaption id="caption-attachment-15864">Output</figcaption>

- If you want to save this calendar, go to the **File tab, select** the **Save** option.

## Add a Yearly Calendar to Excel:

You can also insert the yearly calendar in the worksheet, follow the below steps.

- Go to the **Kutools Plus Tab, select** the **Worksheet** option, **choose** the **Perpetual Calendar** option from the drop-down menu.

![Choose the Perpetual Calendar option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Perpetual-Calendar-option.png)<figcaption id="caption-attachment-15860">Choose the Perpetual Calendar option</figcaption>

- It will open the **Perpetual Calendar Dialog Box.**
- You need to **select January** from the **From** drop-down list and **select December** from the **To** drop-down list.

![Perpetual Calendar Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Perpetual-Calendar-Dialog-Box.png)<figcaption id="caption-attachment-15861">Perpetual Calendar Dialog Box</figcaption>

- Now, you need to **click** the **Create** button and the yearly calendar is created in the new workbook.
- In this workbook, each sheet contains every month of the year 2020 ( **From January-2020 to December-2020** ).

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-19.png)<figcaption id="caption-attachment-15862">Result</figcaption>

- You can **click** the **File Tab** and **select** the **Save** option to save this file.

## Wrap-Up:

In this guide, you can easily understand the steps to **Insert a Monthly or a Yearly Calendar in Excel Office 365** using **Kutools** with examples. Give your **suggestions** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Highlight Active Cell Row and Column in Excel ](https://geekexcel.com/highlight-active-cell-row-and-column-in-excel-office-365/)
- [How to Clear All Formatting of a Range in Excel?](https://geekexcel.com/how-to-clear-all-formatting-of-a-range-in-excel-office-365/)