Create a calendar by using a template (2024)

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 Create a calendar by using a template (1).

  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.

Create a calendar by using a template (2)

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.
Create a calendar by using a template (3)
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.

    Create a calendar by using a template (4)

  3. Under Choose an option, click View only.

    Create a calendar by using a template (5)

  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

Create a calendar by using a template (2024)
Top Articles
Latest Posts
Article information

Author: Lilliana Bartoletti

Last Updated:

Views: 6457

Rating: 4.2 / 5 (53 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Lilliana Bartoletti

Birthday: 1999-11-18

Address: 58866 Tricia Spurs, North Melvinberg, HI 91346-3774

Phone: +50616620367928

Job: Real-Estate Liaison

Hobby: Graffiti, Astronomy, Handball, Magic, Origami, Fashion, Foreign language learning

Introduction: My name is Lilliana Bartoletti, I am a adventurous, pleasant, shiny, beautiful, handsome, zealous, tasty person who loves writing and wants to share my knowledge and understanding with you.