Creating a calendar in Microsoft Excel is simple and easy. All you need is the program and a printer to print your calendar once you’re finished.
Open the program. Left click on the “A” column and drag your mouse to the “G” column. Right click on the “G” and select column width. A small window will open prompting you to enter a width amount. Enter “16.57.” Click “OK.”
Click page layout. Click orientation. Click landscape. This will make your calendar print sideways on the paper. This maximizes the size of your daily blocks and makes the calendar more functional by allowing you to write in the blocks.
Adjusting the Row and Column Sizes
Right click on row 1. Click “row height.” Change the height to “2.5.” Row 1 will be used for our days of the week.
Days of the Week
Click inside cell A1. Type “Sunday.” Click inside cell B1. Type “Monday.” Click inside cell C1. Type “Tuesday.” Click inside cell D1. Type “Wednesday.” Click inside cell E1. Type “Thursday.” Click inside cell F1. Type “Friday.” Click inside cell E1. Type “Saturday.”
Highlight cells A1 through G1. Click on the center text alignment button. This button is on your toolbar and looks like little lines. This button centers the text you typed.
Now right click on the number 2 in Row 2. Click “row height.” Type “98.” Do the same for Rows 3 through 6. This will be the blocks for the dates.
Next, type in the dates in each of the blocks. For example, January 2009 begins on a Thursday, so type the number “1” in cell E2. When you click to the next block, notice the number is in the lower right-hand corner and is small. You will adjust this later. Before we fix this, write dates in each of the boxes. Januar 2009 has 31 days.
Now, highlight cells A2 through G6. Do this by left-clicking in cell A2 and holding the mouse button down and dragging the pointer down to cell G6.
Right-click anywhere in the highlighted area. Click on the down arrow beside of the number “11.” This is the font size. Click “20.” This increases the size of the date, but leaves room for you to write in the blocks.
Naming the Month
Click on the “Insert” tab. Click “Word Art.” Select a style. You will then see “Your text here” in the middle of the screen. Type “January.” You will see the change.
Now move your pointer arrow over the dashed line around the January text. When the arrow becomes a cross with arrows, left click and drag the box to the upper left where there is blank space in Row 2.
Blocking out the Dates
Now highlight A1 through G1. Click on the box border arrow found in the font area of your toolbar. Click “All borders.”
Highlight E2 through G2. Click “All borders.” Highlight A3 through G6. Click “All borders.” Highlight A1 through G1. Click “Thick box border.” Highlight A1 through G6. Click “Thick box border.”
You’re Ready to Print!
Now go to print preview and look at your creation. Play around with fonts and text sizes to see what you like the best.
Now that you’ve created one calendar in Microsoft Excel, use this as a template to change around the dates, box borders and text for other months.