(Create calendars for 2021, 2022, 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)
Back-to-back printing instructions
Below are instructions for printing out your personalized double-sided 12-month
Excel 2007 (Windows) and Excel 2008 (Mac) users,
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.