Free Photo Calendar

Want to create a photo calendar using your own photos? Our new Photo Calendar Template makes it very easy to insert your photos as well as add events and customize the calendar, all from within a spreadsheet. Take a look at the two printable calendars listed below that were created using the picture calendar template.

Printable Photo Calendars

The following photo calendars feature photos taken by professional illustrator Hala Swearingen. She takes hundreds of photos as background research for her illustrations, and I have licensed a few to create the following Flowers and Seasons photo calendars. Take a look at her work at ArtByHala.com. You may print as many copies of these calendars as you need, but the calendars may not be hosted, sold, or distributed via other websites.

	Flower Photo Calendar 2013 Flower Photo Calendar (.pdf) 2014 Flower Photo Calendar (.pdf) Printable photo calendar designed for 8 1/2 x 11 paper.
	Seasons Photo Calendar 2013 Seasons Photo Calendar (.pdf) 2014 Seasons Photo Calendar (.pdf) Printable photo calendar designed for 8 1/2 x 11 paper.

Photo Calendar Template

for Excel and OpenOffice

View Screenshot

Like This Template?

Download Now Type: .ZIP Archive
Contents: .XLS (Excel 2003+)
Size: ~350KB

Template Details

Requirements
Microsoft Excel® 2003 or Later

License
Personal Use Only

Questions?
Contact Us >

Support
How to Extract a ZIP File >


OpenOffice Version - 2012
OpenOffice Version - 2013

These photo calendar spreadsheets are blank 12-month calendars, with each month on a separate worksheet. You can add events as needed and otherwise customize the calendar, as well as insert your own photos and pictures.

The download is a .zip file containing blank photo calendars for 2011, 2012, 2013, and 2014.

Photos not included. The template is for your personal use only (see license). As an addendum to the normal license, you may make as many printed copies of the calendar as you want. The spreadsheet may not be distributed on the web, but you may make a PDF version of your calendar to share with your club, school, etc. provided that you own the rights to the photos and pictures that you will be sharing.

"No Installation, No Macros - Just a simple spreadsheet - An original creation by Dr. Jon Wittwer of Vertex42.com"

Using the Photo Calendar Template

Adding Photos: With Excel 2002/2003, you insert images by going to Insert > Picture > From File and selecting your photo. After you insert your photo, you'll probably need to resize it. To preserve the aspect ratio of your picture, hold down the Shift key as you resize the photo from the corner. To align the photo to the grid in Excel, hold down the Alt key (or Alt+Shift if you are also resizing the photo).

Printing: The photo calendar template is designed to be printed on 8 1/2 x 11 paper in Portrait format. When resizing the photo, try to align the right edge to the right side of column N. If the photo is outside the print area, you can end up with some weird results.

If you are binding the 8 1/2 x 11 photo calendar on the top or side, you can print a single month per page or print on the front and back of each page.

Creating a Mini Photo Calendar

The photo calendar template was also designed to allow you to print a mini folding wall calendar which when folded is the size of a half sheet of paper. Printing this type of calendar is very tricky because of the crazy order of the photos and calendars and having to print some pages upside down on the backs of other pages. I've provided the following illustration to show how to print the pages of the picture calendar.

When using the picture calendar template to create this mini calendar, the photo printed above each calendar won't necessarily be the photo for that particular month. For example, to print the front side of page 3, the photo for December is on the top half of the page and the February calendar is on the bottom half.