Photo calendar 2025 (UK)
for Microsoft Excel
Free printable templates for Microsoft Excel
to create a photo calendar (UK) for 2025
Advertisement
Find the right photo calendar for 2025
One month per page
Templates 1 to 3 have 12 pages, one for each month, on A4 in portrait format. Template 1 has a box for notes on every day and takes a photo up to 10x15cm (4x6in) upright or 13x18cm (5x7in) across. Template 2 has large, clear numerals that are easy to read from a distance, and template 3 lists the days in three columns with a line for notes next to each one - handy for birthdays. Both take photos up to 13x18cm (5x7in) either way round.
Templates 1 to 3 have 12 pages, one for each month, on A4 in portrait format. Template 1 has a box for notes on every day and takes a photo up to 10x15cm (4x6in) upright or 13x18cm (5x7in) across. Template 2 has large, clear numerals that are easy to read from a distance, and template 3 lists the days in three columns with a line for notes next to each one - handy for birthdays. Both take photos up to 13x18cm (5x7in) either way round.
The whole year on one page
Template 4 puts the whole year 2025 on a single A4 page, with room for one photo up to 10x15cm (4x6in) upright or 13x18cm (5x7in) across. It is the one to choose for a single special picture: a family portrait for the grandparents, a photo of your team or club, or a picture of your shop for customers.
Template 4 puts the whole year 2025 on a single A4 page, with room for one photo up to 10x15cm (4x6in) upright or 13x18cm (5x7in) across. It is the one to choose for a single special picture: a family portrait for the grandparents, a photo of your team or club, or a picture of your shop for customers.
Landscape
Template 5 has 12 landscape pages with the days of the month in a single row, which leaves a wide space for a photo up to 13x18cm (5x7in) across, such as a scenic view or a holiday picture.
Template 5 has 12 landscape pages with the days of the month in a single row, which leaves a wide space for a photo up to 13x18cm (5x7in) across, such as a scenic view or a holiday picture.
Bank holidays and week numbers
All templates mark the bank holidays of England and Wales for 2025 in red, and templates 1, 2 and 4 also show the week numbers. Scotland and Northern Ireland have some different bank holidays - see bank holidays 2025. The bank holiday dates have been checked against the official list on GOV.UK, so you can plan around them with confidence.
All templates mark the bank holidays of England and Wales for 2025 in red, and templates 1, 2 and 4 also show the week numbers. Scotland and Northern Ireland have some different bank holidays - see bank holidays 2025. The bank holiday dates have been checked against the official list on GOV.UK, so you can plan around them with confidence.
Making your photo calendar
Click into the empty space above the calendar and insert your photo with Insert → Pictures (choose "Place over Cells" in current versions of Excel), then drag a top corner until the whole picture shows - anything taller than the space is cut off. You can also type in birthdays and appointments and shade special days in colour before you print - our FAQ shows how to add your own dates, colours or logo.
Click into the empty space above the calendar and insert your photo with Insert → Pictures (choose "Place over Cells" in current versions of Excel), then drag a top corner until the whole picture shows - anything taller than the space is cut off. You can also type in birthdays and appointments and shade special days in colour before you print - our FAQ shows how to add your own dates, colours or logo.
A personal gift
Your own photos turn it into a personal present for family and friends, and pictures of your club, school or business make it a free gift for members or customers.
Your own photos turn it into a personal present for family and friends, and pictures of your club, school or business make it a free gift for members or customers.
Photo calendars 2025 for Microsoft Excel,
portrait orientation (4 templates)
Template 1:
Photo calendar 2025 (UK)
portrait, standard
- photo calendar for 2025: 12 pages, one month per A4 page, portrait orientation (vertical)
- space for a photo in the top half of each page: up to 4x6in / 10x15cm portrait (vertical) or 5x7in / 13x18cm landscape (horizontal)
- month grid from Monday to Sunday with a box for notes on every day and a week number column on the left
- UK edition with the England and Wales bank holidays named in red
- good for a family calendar: birthdays, appointments and school dates go straight into the day boxes
- fully editable and customisable
Download template 112 pages · 24 KB · xlsx file
Template 2:
Photo calendar 2025 (UK)
portrait, large numerals
- photo calendar for 2025: 12 pages, one month per A4 page, portrait orientation (vertical)
- large, clear numerals that are easy to read from across the room - good for grandparents and the kitchen wall
- space for a photo up to 5x7in / 13x18cm in portrait (vertical) or landscape (horizontal) orientation
- month grid from Monday to Sunday with a week number column on the left
- UK edition with the England and Wales bank holidays in red figures and named on a line beneath the calendar
- fully editable and customisable
Download template 212 pages · 25 KB · xlsx file
Template 3:
Photo calendar 2025 (UK)
portrait, days in three columns
- photo calendar for 2025: 12 pages, one month per A4 page, portrait orientation (vertical)
- space for a photo up to 5x7in / 13x18cm in portrait (vertical) or landscape (horizontal) orientation
- the days of the month in three columns, each day with its weekday and a writing line for birthdays, appointments or reminders
- UK edition with the England and Wales bank holidays named in red
- without week numbers
- fully editable and customisable
Download template 312 pages · 29 KB · xlsx file
Template 4:
Photo calendar 2025 (UK)
portrait, whole year on one page
- photo calendar for 2025 with the whole year on one A4 page, portrait orientation (vertical)
- space for one photo above the calendar: up to 4x6in / 10x15cm portrait (vertical) or 5x7in / 13x18cm landscape (horizontal)
- the twelve months as small grids from Monday to Sunday in three rows of four, each with a week number column
- UK edition with the England and Wales bank holidays highlighted in red and listed with their dates beneath the calendar
- good as a small present or a year planner with a personal photo - one sheet for the fridge or the desk
- fully editable and customisable
Download template 41 page · 23 KB · xlsx file
Photo calendar 2025 for Microsoft Excel,
landscape orientation (1 template)
Template 5:
Photo calendar 2025 (UK)
landscape
- photo calendar for 2025: 12 pages, one month per A4 page, landscape orientation (horizontal)
- space for a landscape (horizontal) photo up to 5x7in / 13x18cm - good for wide views, holiday scenes and group photos
- all the days of the month in a single row across the bottom of the page, each with its weekday above
- UK edition with the England and Wales bank holidays in red figures and named on a line beneath the dates
- without week numbers
- fully editable and customisable
Download template 512 pages · 28 KB · xlsx file
Making your photo calendar
Photo calendar ideas
Gifts for the family
A homemade photo calendar is a present that gets looked at every day: 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, or a family recipe calendar with a picture of the dish on each page.
A homemade photo calendar is a present that gets looked at every day: 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, or a family recipe calendar with a picture of the dish on each page.
Pets, gardens and hobbies
Make a pet calendar starring the dog or the cat, follow your garden or allotment through the seasons, or fill the pages with your favourite walks, cycle rides, holiday snaps or a project such as a house renovation, month by month.
Make a pet calendar starring the dog or the cat, follow your garden or allotment through the seasons, or fill the pages with your favourite walks, cycle rides, holiday snaps or a project such as a house renovation, month by month.
Schools, clubs and businesses
A class calendar with the children's drawings or a group photo makes a lovely end-of-term present for parents. Clubs and teams can give members a calendar with photos from the season, and a small business can show its products, its shop or its team and add its own logo alongside the Calendarpedia logo.
A class calendar with the children's drawings or a group photo makes a lovely end-of-term present for parents. Clubs and teams can give members a calendar with photos from the season, and a small business can show its products, its shop or its team and add its own logo alongside the Calendarpedia logo.
Getting your photos ready
Choosing the photos
Photos that match the time of year work best: a frosty walk for January, spring flowers for April, a beach day for August, autumn leaves for October. Use the original photos from your camera or phone rather than copies sent through messaging apps, which are often compressed and can look blurred in print.
Photos that match the time of year work best: a frosty walk for January, spring flowers for April, a beach day for August, autumn leaves for October. Use the original photos from your camera or phone rather than copies sent through messaging apps, which are often compressed and can look blurred in print.
Printing the photos
The photo spaces are made for standard prints of 10x15cm (6x4in) or 13x18cm (7x5in), so you can order them from a high-street photo kiosk or an online photo service, or print them at home on photo paper and trim them to size.
The photo spaces are made for standard prints of 10x15cm (6x4in) or 13x18cm (7x5in), so you can order them from a high-street photo kiosk or an online photo service, or print them at home on photo paper and trim them to size.
Paper and hanging
Thicker paper or thin card makes the pages sturdier and stops glue showing through. Punch a hole at the top centre to hang the calendar on a nail or a hook, hold the pages together with a bulldog clip or two binder rings, or ask a copy shop to spiral-bind or comb-bind them.
Thicker paper or thin card makes the pages sturdier and stops glue showing through. Punch a hole at the top centre to hang the calendar on a nail or a hook, hold the pages together with a bulldog clip or two binder rings, or ask a copy shop to spiral-bind or comb-bind them.
Photo calendar 2025 or perpetual photo calendar?
Dated or undated
The 2025 photo calendars have the dates, the days of the week and the bank holidays of 2025 printed, so they are ready to hang on 1 January. The perpetual photo calendars have the same layouts without a year and without days of the week, so you can start them in any month and make the same calendar again next year.
The 2025 photo calendars have the dates, the days of the week and the bank holidays of 2025 printed, so they are ready to hang on 1 January. The perpetual photo calendars have the same layouts without a year and without days of the week, so you can start them in any month and make the same calendar again next year.
As a present
For a Christmas present, start choosing the photos in November 2024 and print the calendar in early December, so it is ready to hang in time for the new year. For a present later in the year, the perpetual photo calendar is the better choice, because it can start in any month. In 2025, Mother's Day (Mothering Sunday) falls on Sunday 30 March and Father's Day on Sunday 15 June - two good occasions to give a perpetual photo calendar full of family photos.
For a Christmas present, start choosing the photos in November 2024 and print the calendar in early December, so it is ready to hang in time for the new year. For a present later in the year, the perpetual photo calendar is the better choice, because it can start in any month. In 2025, Mother's Day (Mothering Sunday) falls on Sunday 30 March and Father's Day on Sunday 15 June - two good occasions to give a perpetual photo calendar full of family photos.
Ideas for your 2025 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 10x15cm print - then drag it into place. Corrections and Colour 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 10x15cm print - then drag it into place. Corrections and Colour 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 in the print preview 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 in the print preview 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.co.uk") 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 standardised as ISO/IEC 29500, which Excel has used since Excel 2007.
- 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 don't have Microsoft Excel installed, use Excel for the web (Microsoft 365 for the web, formerly Office Online, free with a Microsoft account) or one of the free alternatives to Microsoft Office: LibreOffice Calc or FreeOffice PlanMaker (and others). 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 iPhone, iPad and Android and the Google Sheets app both open these files, so you can add or check an entry on the move and print the template later from any computer. - Your own dates, colours 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, colours or logo. - Printing in black and white
To save colour 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 colours, and you can type into the day cells and change the fill colours 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, colours or logo.




