Printable 12-Month Photo Calendar
The 12 Month Photo Calendar template after printing and spiral binding.
Calendar Photo: Unsplash/Shelby Deeter

12-Month Photo Printable Calendar Template for Microsoft® Excel®

This template lets you download a printable 12 month photo calendar which you can then customize and add photos to using Microsoft Excel spreadsheet software.

Calendars for 2023 and earlier are free to download. To access 2024 and beyond, log in here or subscribe now.

Features and Customization Options

  • Each file contains 25 pages: 1 cover page, 12 pages for photos, and 12 monthly calendar pages
  • Microsoft® Excel® format (Requires Microsoft Excel)
  • Multi-year access (Create calendars for 2024, 2025, or any other year, 1 AD - 10,000 AD)
  • Add your events, change font/grid colors, and add pictures
  • Holidays (US, Canada, UK, and Australia)
  • Letter and A4 paper sizes
  • Custom start day of the week
  • Multiple language support (English, Español, Deutsch, Français, Italiano, Danish, and Nederlands)
Photo of finished 12 month wall calendar
Calendar Photo: Unsplash/Frank McKenna
Close-up of month view of 12 month photo calendar
Paste your photos into the Excel document (they can even be added to the day squares), then follow the back-to-back printing instructions below. After printing, it is ready to bind.

Back-to-back printing instructions

Below are instructions for printing out your personalized double-sided 12-month photo calendar.

Excel 2007 (Windows) and Excel 2008 (Mac) users, click here for pre-print formatting instructions.

1. Print the front pages
With your Microsoft Excel calendar file open and quality photo paper inserted in your printer, select the first 13 tabs of the Excel workbook (do this by holding down the SHIFT button, then click the Cover tab, then the December tab). Next, click File->Print to open the Print dialog. Set page range to "All", set print what to "Active sheet(s)", and click OK to print.
2. Sort the front pages according to your printer's page order
After your front pages have printed, note which page was printed out last.

If the Cover was printed last: take the December page out and set aside. Then sort the stack so that the November page is on the top and the cover page is on the bottom.

If December was printed last: take the December page out and set aside. Then sort the stack so that the Cover page is on the top and the November page is on the bottom.

If a different page printed last: your printer isn't printing in expected order, so you will need to either print the back photos one-by-one, or change your Printer Properties' page order to 'Front to Back' or 'Back to Front' and test print the Cover thru December tabs. If they print in order, you can continue following the instructions above and below.

3. Rotate and reinsert the stack of page fronts
Insert the sorted stack into your printer, rotated 180 degrees so that the photos are correctly printed on the backs.
4. Print the back pages
In Excel, select all 12 of the photo page tabs (hold the SHIFT button and select the January photo tab, then the December photo tab). From the Print dialog, set 'page range' to "All", set 'print what' to "Active sheet(s)", and click OK to print.
5. Bind and your photo calendar is finished!
Make sure your stack is in the correct order. If you have the materials and tools for binding, you can do it yourself, or bring it to your local printer for finishing. Printers like Staples and FedEx Office can usually have it bound and finished in a few minutes for just a couple of dollars.

Microsoft Excel help:
Print a worksheet or workbook

Inkjet paper from Staples:
Epson® High Quality Inkjet Paper, Matte Finish

Excel tips

To break a line, press Alt-Enter at the end of each line of text.

To insert a picture, first select your square, then select Insert->Picture->From File. Find your picture, then drag and resize to fit your square.

Ready to get started? Subscribe now and start downloading calendars in minutes!

© 2006-2024 CalendarsQuick is a service of Auxant Software, LLC. All rights reserved.