How to Create a Calendar Project in Excel

Written by mara shannon
  • Share
  • Tweet
  • Share
  • Email

There are many different available templates for creating calendar projects in Microsoft Excel. You can find templates on the Microsoft Office website for different calendar years, months and designs, including academic calendars (which span a school year), calendars with pictures or different-coloured borders and calendars for previous years. You can alter calendar templates based on your individual needs and preferences.

Skill level:
Moderately Easy

Things you need

  • Microsoft Excel

Show MoreHide


  1. 1

    View the calendar templates on Microsoft Office's website (see Resources).

  2. 2

    Choose "Excel" from the "Filter by Product" drop-down menu in the left-hand column of the page.

  3. 3

    Choose the year (or multiyear calendar) you would like and browse the selection of templates.

  4. 4

    Choose and download a template. Rename the file "Calendar.xlt."

  5. 5

    Open My Computer and double-click the C drive. Open the folder "Documents and Settings" and double-click your user name.

  6. 6

    Open the folder "Application Data." (If you cannot see this folder, go to "Tools" and "Folder Options," click the "View" tab and select "Show Hidden Files and Folders," then click "OK.")

  7. 7

    Open the folder "Microsoft," then the folder "Templates." (The address bar should read "C:\Documents and Settings\user\Application Data\Microsoft\Templates.") Copy and paste "Calendar.xlt" into the "Templates" folder.

  8. 8

    Open Microsoft Excel go to "File" and "New." Under the menu "Templates," select "On My Computer," then double-click the "Calendar.xlt" template to open it.

  9. 9

    Edit the calendar's appearance. For example, you can right-click a cell and select the "Pattern" tab to change the background colour, or the "Border" tab to change the border style and colour. You can also change the size of the calendar cells, giving you more or less room to write, or the font used for the dates.

Tips and warnings

  • Many of the calendar templates are for Excel 2007. Your choices may be limited if you have an earlier version of Microsoft Office.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.