Excel Calendar pt. 3: Adding Months

You may wish to download a copy of the file below by CLICKING on it or you can download a copy HERE

Now it’s time to take that template page and create our first month. I’ll start my calendar at January, but often a calendar will start in September! When you print a proper calendar, you actually need to print pages in multiples of 4, so a typical calendar has at least 1 extra month. Plus, you often get a new calendar before the year is over, and it’s nice to be able to use the calendar when you get it. If you want to start yours in December or right now, feel free to add extra pages using these instructions!

First, find that template tab at the bottom of the screen and Right-Click. You want to select Move or Copy… from the menu that pops up:

In the next window, you want to select (move to end) and make sure you turn on Create a copy:

Then you will have a tab that’s called template (2). Double click on that tab to change the name. I’ll call mine January 2024:

When you do that, you’ll see that same text appear at the top of the page in that Header area

January 1, 2024 is actually a Monday, so we want to move the first over a day. All you need to do is select the cell where the 1 is and backspace to delete whatever is in the box:

You’ll notice that the first is now on a Monday!

You could do each individual box, but it’s easier to get rid of a bunch at a time if you have more than one day to remove. Go to the bottom row and select all of the date from 35 to 41 by clicking and dragging:

On the Home menu, you’ll see an eraser. Click into it and choose Clear All:

January has 31 days, so go ahead and select everything from 32 to 34 and Clear All for those cells as well:

I’ll Clear that first cell as well. In the end, my January calendar looks like this:

Start at the top and repeat the process for every month. Remember to start from the template page every time.

and so on!

Tell Mr. Robson what's on your mind!