Hi. In this Excel tutorial, we’ll go over how you can make your own 12 month wall calendar using Excel. To do this, we'll resize our
worksheet so that we can use legal size paper. To make it easier, we'll start with doing some formatting
to our sheet. But, first, I want to change my workbook view to Page Layout.
This isn't necessary, but I prefer it for viewing my calendar as I’m making it and ensuring that I stay within just 1 page. Plus, I
can see the Header as I'm working. And, if you enjoy this tutorial, don’t forget to Like the video and subscribe to the channel for even more
tips. So, we'll need to change our paper size for this document. So, my Excel defaults to letter size, but we need to change this so we
can create a legal size document. So, from the Page Layout tab, in the Page Setup section, click on the small arrow, here,
and, where you see the Paper Size drop-down, select Legal and click OK. Oh, and for my
Margins, I’m going to select the 1” margins with 0.5” Header and Footer.
Next, select the entire sheet and, from the Home tab, we'll Bold everything, and, in the Alignment section, we'll center everything
horizontally and vertically, and we'll change our font size to 12pt font. And, by the way, I'm using the Calibri font type for this.
Let's type 2019 CALENDAR in the Header and we'll Bold this,
make it a 26pt font, and we'll use this orange color for the font color. So, this wall calendar will have 6 months on each side. So, let's
format our columns for this. So, select columns A through G, and right-click, and select Column Width and we'll set that to 0.43” and click OK.
Column H, right-click and we'll set that to half an inch and click OK. And then columns I through O will also be set at 0.43"
Starting in cell A2, select cells from A2 through G2 and click Merge & Center. And I'm going to use this orange fill for the fill. The font color in
this cell to white, and change the font size here to 16pt. Then, right-click, go to Format Cells and, in the Number tab, go to Custom and,
here, where it says General, delete that and type 4 M's. This format is so that the cells display the full name of the month.
And click OK. Then, type the MAX formula and reference cells A4 to G4. Now, you can use other formulas, but this is simple enough and
will work. We just need for Excel to read which month name to use. Now, on the row beneath this, type the initial for each day -
doing 1 per cell.
When done, I'm going to use the same orange from before for the font color.
Next, highlight the 7 rows beneath that - so, rows 4 through 10, and right-click. Select Format Cells, go to
Custom and, in General, just type the letter D and click OK.
This is a date format that will display only the day number. So, let's copy the section that
we just formatted, from rows 2 through rows 10, and paste it in cell I2.
Then, let's copy both of these
and Paste them another 5 times.
Now, don't worry that they all currently say January. This will fix itself in a moment. Since this example is of a 2019 calendar, and
January 1, 2019 falls on a Tuesday, we'll just go to the first cell for a Tuesday, which is cell C4 and, here, type 1-01-2019.
From here, just add 1
and copy over, being careful at the beginning of that next week, to add 1
to the end of the prior week.
And then, now, you can copy this down
until January is complete.
Let's delete these 2 days that will be in the next month. And, because January ended on a Thursday, go to the first Friday of what will
be February and just add 1 to that last day of January.
And then, now, we can fill this
just like we did for the month of January. And I'm actually just going to copy this over,
deleting those last 2.
And, notice how when we did that, our month name updated to February.
And, from here, just repeat this for the remaining months to complete your calendar.
And, when done, simply print your calendar and display it on your wall. So, I hope you enjoyed this Microsoft Excel tutorial on how to
create a 12-month wall calendar. If you did, please make sure to Like the video and don’t forget to subscribe to this channel. Thanks!