Create a calendar by using a template

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 .

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.

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).

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.

   

3. Under Choose an option, click View only.

   

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