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.

Create a Calendar
Settings

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

Year

Margins

Smaller on sides

Larger on sides

Include my holidays

Include my schedule

Paper size

Week starts on

Language

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.

Tip: If you are new to printing double-sided wall calendars or you have a new printer, we recommend first doing a test run using scrap paper (no photos yet inserted into the file) before using high quality photo paper and printing the final calendar.

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!