Excel Calendar Template
The free Excel Calendar Template on this page was one of the very first templates I created for Vertex42.com back in 2003. I've since added many other types of calendar templates, printable calendars, yearly calendars, planners, and schedules that you can find listed to the right. However, if you are looking for a professionally designed and easy-to-use 2013 calendar template, go ahead and use the files contained in the Excel Calendar Template download on this page.
One of the great things about using an Excel calendar is the complete flexibility it gives you for entering events, highlighting cells, formatting, etc. It's kind of funny that a spreadsheet tool like Excel, orginally created for accounting purposes, has turned into one of the most popular tools for creating custom calendars.
New!! Theme-Enabled Excel Calendar Templates
Download Vertex42's new theme-enabled calendar templates for Excel 2007/2010.
Create great-looking calendars in seconds by just selecting the theme of your choice from Excel's gallery of colors and fonts.
All of the calendars shown on the right were created using the same workbook.
Excel Calendar TemplateThe Original - over 2.5 million downloads - For 2013 and Beyond!
Contents: .XLS (Excel 2003+)
Size: ~550KB, V 1.4.2
(Theme-Enabled XLSX Version)
(Theme-Enabled XLSX Version)
Download Free Calendar Templates for 2013
Full-Year Calendars for 2013, 2014: The most popular files in the download are the no-formula/no-fuss yearly calendars named 2013-calendar.xls, 2014-calendar.xls, etc. These yearly calendars include a different month of the year on separate worksheet tabs, and don't have any complicated formulas. You can easily add events, birthdays, anniversaries, and holidays, to create calendars for your family, club, or organization. Some U.S. holidays and observances are already included.
The file named ExcelCalendarTemplate_v1-4.xls is the original free calendar template by Vertex42.com. It is perpetual, meaning that it can be used to create a monthly calendar for any month of any year (after 1900). It uses some fancy Excel features such as macros and form controls (for adjusting the color scheme), conditional formatting (for controlling the background color of some cells), named ranges (for working with formulas and the macros), and linked images (for displaying mini previous- and next-month calendars).
This spreadsheet was the first calendar template available on Vertex42.com, and 2,500,000 downloads later, it is still one of the most popular. For the more advanced Excel users, I can recommend the newer (yet still free) Perpetual Calendar template.
For Google Docs: Want to create a calendar to share privately with your family or group? Try using the Vertex42 calendars in Google Docs:
For OpenOffice.org: Download our 12-month 2013 Calendar as an OpenOffice Calc spreadsheet template (.ots file):
Rate and Review the Excel Calendar Template
To view and write reviews, click on the button below.
How to Use this Calendar Template
To use this calendar template, you will first need to extract the .xls files from the .ZIP archive. You can learn how to do that on the Support/FAQ Page.
The full-year calendars included in the download don't contain macros, but the file "ExcelCalendarTemplate_v1-4.xls" does. To use the buttons that modify the color scheme, you'll need to enable macros when you open this file (which you can learn how to do using Excel's help system).
After that, it's just a matter of choosing the month and year you want, modifying the color scheme to your liking using the scroll bars, and then printing the calendar.
If you get weirded out by the background colors changing, don't worry - that's just conditional formatting at work (which you can also read about in Excel's help system).
Excel Calendar PRO!
With the creation of the perpetual calendar template, Excel Calendar Pro is almost obsolete. However, it still serves its purpose. Excel Calendar Pro lets you include holidays and other yearly events (up to 6 per day) and then it automates the creation of stand-alone multiple-month calendar workbooks. This allows you to create yearly calendars that start with any month you choose. So, if you like the free calendar template above, you can take the next step and purchase Excel Calendar PRO.
Other Free Excel Calendars
- Yearly Calendar Template - Vertex42.com - Download, customize, and print a free yearly calendar using Excel.
- Variety of Excel Calendars - wincalendar.com - The site also includes calendar templates for Word.
- 4/22/2013: Planning a Wedding on a Calendar Is a Smart Idea - Wedding planning can take as long as two years from some determined brides and grooms. Employing the use of a wedding calendar to nail down the specifics can go a long way to creating that perfect day – even 24 months in advance.
- 4/16/2013: Time Management A Lifelong Lesson for Kids - Learning to manage time effectively is a skill many adults have trouble mastering. Teaching kids at a young age how to manage time properly using a simple paper calendar can go a long way to keeping kids on track for a more productive future.
- 4/8/2013: Create a Mom's Night Out Calendar for Friends - Moms need time for themselves in order to be a better parent. Mom friends can create a simple paper calendar filled with noted girls' night events throughout the year to ensure they get some quality time away from home on a regular basis.
- 4/2/2013: Never Forget A Baby's Milestone - Milestones with our children may only happen one time so it is important for parents to make note of this progress each time they occur. Use a simple paper calendar to record the dates and times when your baby first walked, talked, and smiled so you'll never forget the precious moments.