Click OK, and when you do a print preview you’ll find that your calendar template is formatted on one sheet and ready to print!The next month, just open up the same Excel file (the month will already be correct), renumber the days and click Print — it’s as simple as that!Clicking Merge & Center turns all of the highlighted cells into one collective cell, and then centers your title in the middle of the highlighted region.
While it may sound confusing, as you give it a try you’ll find that filling in the days only requires a few clicks and less than 5 minutes.
Finally, you’re ready to print out your calendar to a nice clean paper so you can pin it up on your wall.
It requires a little extra work, but it looks very cool.
The first thing you’ll need to do is create the weekday header as well as the month title.
Finally, you can either leave your template as it is (so you can write in the days yourself) and move ahead to step 3, or you can add in the days using Excel.
Instead of going through and manually typing in “1” to “30”, you can save a lot of time by using Excel’s Auto Fill feature.This means you’ll end up with parts of it on two pages.To fix this, go to Page Layout and bring out the Page Setup window by clicking on the tiny arrow in the bottom right.By this point, your calendar should look like this.While this looks absolutely fantastic within the Excel sheet, it won’t print properly because the edge of the calendar template goes beyond the printable page, as indicated by the dashed vertical line.And there you have it, your custom calendar template that you can reuse over and over again.