Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Many calendar templates are available for use in Excel. A template provides a basic calendar layout that you can easily adapt for your needs.

You can download calendar templates with useful and creative themes when you click File > New in Excel.

  1. Select Search for online templates, type calendar, and select the magnifying glass Start Searching button.

  2. Click on a template that you are interested in and then click Create.

  1. On the File menu, click New from Template.

  2. On the rightmost side, in the Search All Templates search box, type Calendar.

  3. Pick a calendar template you want and click Create.

    You can easily apply your own look to a calendar. Calendar templates are formatted by using themes that enable you to apply fonts, colors, and graphic formatting effects throughout the workbook with just a click. On the Page Layout tab, under Themes, select from dozens of built-in themes available in the Themes gallery or find options to change just the theme fonts or theme colors.

    Important: Formulas exist in all cells that display a date, as well as in those cells in the date rows that appear blank. These formulas enable the calendar to update automatically. If you manually change the data in those cells, the calendar will no longer be able to update automatically.

See also

Differences between templates, themes, and Word styles

Create and use your own template in Office for Mac

Making a calendar like this while you're online is quick and easy.

Calendar template in Excel for the web

Choose one of our calendar templates, and open it in an Office for the web program to make it yours (some calendars are for editing in Excel for the web, some in Word for the web, and others work in PowerPoint for the web).

Tip: If you're already in Excel for the web, see all the calendar templates by going to File > New, and then below the template images click More on Office.com.
click More on Office.com
You'll be on the Templates for Excel page. In the list of categories, click Calendars.

As you work on the calendar, you'll probably want to rename it.

Share your calendar

When you're finished, print it out or share it online. You can do this with the calendar still open in Excel for the web. No need to save it first (that's already done for you).

Print it

To print it, press Ctrl+P, and click Print to see a preview. Click Print again to print the worksheet.

Tip: To print all the sheets in the template, click on each sheet tab and print them one at a time.

Share it

To share it online, send a link:

  1. Near the top of the screen, click Share.

  2. Under Share, click Get a Link.

    Click Get a Link

  3. Under Choose an option, click View only.

    Click Get a Link

  4. Click Create Link.

  5. Click on the web address to select it, and then copy and paste it into an email, message, or post.

Tip: If you have a blog or website, you can embed a view of your calendar there.

See also

Free Excel Online templates on Office.com

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Excel calendar templates

Try it with templates

Where are my custom templates?

Get accessible templates for Office

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×