Photo calendar 2018: 5 free editable Excel templates
Insert your own photos in Excel or Google Sheets,
then print a personalized 2018 calendar.
Advertisement
Find the right photo calendar for 2018
Twelve pages, one for each month
Templates 1, 2 and 3 give each month its own portrait page, with the photo space above the calendar. Template 1 has a standard month grid and takes a photo up to 4x6 inches in portrait or 5x7 inches in landscape orientation. Template 2 has large, easy-to-read numerals, and template 3 sets out the days in three columns with a line next to each day for birthdays and notes; both take photos up to 5x7 inches in either orientation.
Templates 1, 2 and 3 give each month its own portrait page, with the photo space above the calendar. Template 1 has a standard month grid and takes a photo up to 4x6 inches in portrait or 5x7 inches in landscape orientation. Template 2 has large, easy-to-read numerals, and template 3 sets out the days in three columns with a line next to each day for birthdays and notes; both take photos up to 5x7 inches in either orientation.
The whole year on one page
Template 4 puts one photo (up to 4x6 inches in portrait or 5x7 inches in landscape orientation) above the whole year on a single sheet, a quick gift that works as a wall or desk calendar.
Template 4 puts one photo (up to 4x6 inches in portrait or 5x7 inches in landscape orientation) above the whole year on a single sheet, a quick gift that works as a wall or desk calendar.
Landscape pages
Template 5 has twelve landscape pages, each with the days of the month in a single row beneath a photo up to 5x7 inches.
Template 5 has twelve landscape pages, each with the days of the month in a single row beneath a photo up to 5x7 inches.
What is printed
The 2018 photo calendars show the dates and days of the week of 2018 and mark the US federal holidays, including the observed day off when a holiday falls on a weekend. The photo space on each page is left empty, so nothing gets in the way of your picture. Templates 1 to 4 are in portrait and template 5 in landscape, all on US Letter paper (8.5 x 11 inches).
The 2018 photo calendars show the dates and days of the week of 2018 and mark the US federal holidays, including the observed day off when a holiday falls on a weekend. The photo space on each page is left empty, so nothing gets in the way of your picture. Templates 1 to 4 are in portrait and template 5 in landscape, all on US Letter paper (8.5 x 11 inches).
Edit in Excel, then print
Click the empty photo space, choose Insert > Pictures and drag the corners of your photo until it fills the space; in Google Sheets, use Insert > Image > Image over cells. Type in birthdays and other dates, or add your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). Print a test page first to check how the photos sit on the paper. Prefer to glue photos on by hand? The same photo calendars are available as PDF files.
Click the empty photo space, choose Insert > Pictures and drag the corners of your photo until it fills the space; in Google Sheets, use Insert > Image > Image over cells. Type in birthdays and other dates, or add your own logo alongside the Calendarpedia logo (our FAQ shows how to add your own dates, colors or logo). Print a test page first to check how the photos sit on the paper. Prefer to glue photos on by hand? The same photo calendars are available as PDF files.
Photo calendars 2018 for Microsoft Excel,
portrait orientation (4 templates)
Template 1:
Photo calendar 2018
portrait, standard layout
- 12 pages (1 page per month), portrait orientation (vertical)
- for photos up to 4x6in in portrait orientation (vertical)
- for photos up to 5x7in in landscape orientation (horizontal)
- US edition with federal holidays 2018
- free to download, editable, customizable, easily printable
Download template 112 pages · 26 KB · xlsx file
Template 2:
Photo calendar 2018
portrait, large numerals
- 12 pages (1 page per month), portrait orientation (vertical)
- with large clear numerals for easy reading
- for photos up to 5x7in in both portrait (vertical) and landscape (horizontal) orientations
- US edition with federal holidays 2018
- free to download, editable, customizable, easily printable
Download template 212 pages · 27 KB · xlsx file
Template 3:
Photo calendar 2018
portrait, days in three columns
- 12 pages (1 page per month), portrait orientation (vertical)
- for photos up to 5x7in in both portrait (vertical) and landscape (horizontal) orientations
- with space for notes (e.g. birthdays) next to each day
- US edition with federal holidays 2018
- free to download, editable, customizable, easily printable
Download template 312 pages · 31 KB · xlsx file
Template 4:
Photo calendar 2018
portrait, whole year on one page
- the whole year on one page, portrait orientation (vertical)
- for one photo up to 4x6in in portrait orientation (vertical)
- for one photo up to 5x7in in landscape orientation (horizontal)
- US edition with federal holidays 2018
- free to download, editable, customizable, easily printable
Download template 41 page · 23 KB · xlsx file
Photo calendars 2018 for Microsoft Excel,
landscape orientation (1 template)
Template 5:
Photo calendar 2018
landscape
- 12 pages (1 page per month), landscape orientation (horizontal)
- for photos up to 5x7in
- US edition with federal holidays 2018
- free to download, editable, customizable, easily printable
Download template 512 pages · 31 KB · xlsx file
Making your photo calendar
Photo calendar ideas
Gifts for the family
A photo calendar works for almost any occasion: a grandparents' calendar with a new photo of the grandchildren for every month, a baby's first year with one month per page, a year in review with the best photo from each month of the past year, or a family recipe calendar with a photo of the dish on each page.
A photo calendar works for almost any occasion: a grandparents' calendar with a new photo of the grandchildren for every month, a baby's first year with one month per page, a year in review with the best photo from each month of the past year, or a family recipe calendar with a photo of the dish on each page.
Hobbies, pets and travel
Show the seasons in your garden, your neighborhood or your favorite park, make a pet calendar starring the dog or the cat, or fill a travel calendar with photos from last year's trips.
Show the seasons in your garden, your neighborhood or your favorite park, make a pet calendar starring the dog or the cat, or fill a travel calendar with photos from last year's trips.
Business, school and clubs
Give clients a calendar with photos of your products, your store or your team, or make a class, club or team calendar with a group photo for every month.
Give clients a calendar with photos of your products, your store or your team, or make a class, club or team calendar with a group photo for every month.
Photo calendar 2018 or perpetual photo calendar?
The 2018 photo calendars have the dates, the days of the week and the holidays of 2018 printed. The perpetual photo calendars have the same layouts without a year, so you can start them in any month or make the same calendar again next year.
The 2018 photo calendars have the dates, the days of the week and the holidays of 2018 printed. The perpetual photo calendars have the same layouts without a year, so you can start them in any month or make the same calendar again next year.
Ideas for your 2018 photo calendar in Excel
Cropping photos to fit the space
Select a photo and use Crop → Aspect Ratio on the Picture Format tab - 2:3 suits a space made for a 4x6 print - then drag it into place. Corrections and Color on the same tab brighten a dark photo or turn it into black and white before you print.
Select a photo and use Crop → Aspect Ratio on the Picture Format tab - 2:3 suits a space made for a 4x6 print - then drag it into place. Corrections and Color on the same tab brighten a dark photo or turn it into black and white before you print.
Checking every page before printing
Type a caption or a birthday into the cells below the photo, then step through every page on the Print screen before you print, so no photo spills onto the next page. Large photos make the file heavy, and Compress Pictures on the Picture Format tab keeps it small enough to email.
Type a caption or a birthday into the cells below the photo, then step through every page on the Print screen before you print, so no photo spills onto the next page. Large photos make the file heavy, and Compress Pictures on the Picture Format tab keeps it small enough to email.
Using the templates
Terms of Use
All templates on this site may be used free of charge, at home, at work and at school, provided that the Calendarpedia logo, the copyright notice with the website address ("© Calendarpedia® www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") stay on the template. The templates may not be sold or built into products that are sold, and the blank templates (or copies with only minor changes) may not be offered for download on other websites. All content on this site is protected by copyright © 2011-2026 Calendarpedia®. All rights reserved. Data is provided 'as is' without warranty of any kind, may contain errors and is subject to change without notice. If you find a mistake, please let us know. Full details are in our Terms of Use.
System requirements and compatibility
Every template is saved in Microsoft Excel (.xlsx) format, the Office Open XML spreadsheet format standardized as ISO/IEC 29500.
- Microsoft Excel
The templates open in Excel 2007 and later for Windows, Excel 2008 and later for Mac, Microsoft 365 and Excel for the web. - Google Sheets
The .xlsx files open in Google Sheets with the layout intact, so you can fill the template in from a browser on any computer, tablet or phone without installing anything. - Free alternatives
If you do not have Excel installed, Microsoft 365 for the web is free to use in a browser, and free desktop alternatives such as FreeOffice PlanMaker and LibreOffice Calc open our templates without formatting errors. Apple's Numbers opens the files too, but the layout may shift, and OpenOffice Calc unfortunately has formatting problems with some of our calendars. - Editing on a phone or tablet
The Excel app for Android and iOS and the Google Sheets app both open these files, so you can add or check an entry away from your desk and print the sheet later from any computer. - Your own dates, colors and logo
Type your entries straight into the day cells, shade the days that matter to you and add your own logo alongside the Calendarpedia logo - our FAQ shows how to add your own dates, colors or logo. - Printing in black and white
To save color ink, you can print any template in black and white. - Older versions of Excel
Excel 2003 and older versions can't open .xlsx files directly. Open the template in Excel for the web or one of the free programs above instead, or use the PDF version of the calendar.
How to open and print these templates in Google Sheets
Download the .xlsx file first. Then either drag it into Google Drive, right-click it and choose Open with → Google Sheets, or open Sheets and go to File → Open → Upload. The template keeps its layout and colors, and you can type into the cells and change the fill colors exactly as you would in Excel.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
To print from Sheets, go to File → Print, set the orientation to landscape or portrait to match the template you chose, and set Scale to "Fit to page" so the template doesn't spill onto a second page. Set Margins to Narrow if you want the grid to fill more of the paper. Because the file sits in Drive, you can share it with a team or a family and everyone works on the same template.
Problems downloading, opening or printing a template?
Our FAQ explains how to print a template in a different size or in black and white, what to do if the edges are cut off, a download doesn't work or a file won't open in Excel or Word, which other programs you can use and how to add your own dates, colors or logo.




