Free Yearly Calendar Template for 2010, 2011

We've created a free yearly calendar in Excel to add to our collection of calendar and scheduling templates. Each of the yearly calendars include 12 months on a single page, beginning with the year and month of your choice. They are easily customizable and there are no macros. See below for more details on the specific formats and styles.

For a ready-made 2010 yearly calendar in PDF format, see our new Free Printable Yearly Calendars.

2010 Yearly Calendar Collection

Try our new Vertex42 Calendar Template on Google Docs!
	Download a free yearly calendar for Excel or OpenOffice from our collection listed below. Create and print yearly calendars for any year, starting with any month. These spreadsheets were designed to be simple to customize. They include the option of choosing Sunday-first or Monday-first, as well. "No Installation, No Macros - Just Simple Spreadsheets" Cost: Free ($0.00) License: Personal Use Only (Applies to all the calendar downloads on this page). Required: Microsoft Excel® 2000, 2002(XP), 2003, 2007, or OpenOffice
Screenshot	Yearly Calendar Template This basic perpetual yearly calendar lets you enter the year and starting month as well as select any day of the week as the first day. Yearly Calendar Template (.xls) \| Download for OpenOffice (.ots)
	Yearly Calendar with Notes If you would like a calendar with a Notes section, try one of the variations below, formatted in landscape or portrait orientation. Yearly Calendar - Landscape (.xls) \| Download for OpenOffice (.ots) Yearly Calendar - Portrait (.xls) \| Download for OpenOffice (.ots)
Screenshot	Yearly Event Calendar This calendar is based on the Yearly Calendar Template above except that it also lets you enter dates for events and holidays into a list and the dates are automatically highlighted in the calendar via conditional formatting. Some US holidays and observances are included. Download for Excel (.xls) \| Download for OpenOffice (.ots)
	Full Year Calendar These spreadsheets contain one full year of monthly calendars (each month on a separate tab) as well as a yearly calendar in landscape format. These are the same files contained within the Calendar Template. For Excel: 2010 Calendar, 2011 Calendar, 2012 Calendar Try our Vertex42 Calendar Template on Google Docs!
	Yearly Calendar with Week Numbers This version includes week numbers. Select between US or ISO week numbering. Yearly Calendar with Week Numbers (.xls)
	Multiple-Year Calendar This spreadsheet includes four yearly calendars on a single page. Multi-Year Calendar (.xls)
	Annual Calendar / Checklist This spreadsheet lists the days of the month by row in a linear format. Originally created as a Resolution Checklist, but has many other uses, as well. Annual Calendar (.xls)

Yearly Calendar Features:

1) Choose the Year and the Starting Month

Enter the starting year and month at the top of the calendar. For example, if you are creating a yearly calendar for school year 2010-2011, you can start with month=8 (August). For those who use a fiscal year for their business planning, this yearly calendar is just right.

2) Sunday or Monday First

Much of the world uses a calendar that starts on Monday rather than Sunday. Our new yearly calendar now includes this option.

3) Vertex42 Style

We enjoy making spreadsheets that are both simple, stylish, and user-friendly. Sometimes creating something with style requires us to use advanced features. For example, the yearly calendar template uses conditional formatting to make the blank cells light blue.

One Month in the Yearly Calendar.

You can delete the conditional formatting if you want and add your own formatting to highlight specific dates in the calendar. To delete the conditional formatting, select all the cells in the calendar and go to Format > Conditional Formatting > Delete.

4) Changing the Calendar Color

Probably the easiest way to change the colors in your yearly calendar is to modify the color via the Color pallette (Tools > Options > Color tab).

Other Yearly Calendars

Excel Calendar PRO - Vertex42.com - This is Vertex42's popular calendar creator for Excel. It can be used to create yearly calendars in which each month is a separate tab or worksheet. It also allows you to dynamically adjust the color scheme.
Yearly Calendar - TimeAndDate.com - This online (web-based) calendar lists holidays and other yearly events for any year that you specify.
Printable Yearly Calendar - Paulding.net - This is another online calendar that lets you include a graphic at the top of the page. However, if you own Excel, you can do much more with an Excel yearly calendar template in terms of adding custom graphics.