Creating the Rows and Columns
Highlight row 1 and 2 and columns A to N, and format the cells to have a border on the edge. Then merge and center the ce lls across row 2 for the space for the name of the month.
Set row 3 height to ¼ inch. This row will be for the names of the days of the week. Highlight A and B, put a border on the outside, and merge and center the cells. Repeat across to N, so that you have 7 boxes for the days for the week.
Now we will make the cells for the days. Set row 4 to a height of ½ inch. Set row 5 to the same height. Make six sets of double cells in total. These will be rows 4 through 15, which allow space for 6 weeks each month. By using two rows for each day, we will have a space to put additional information in the day square.
I originally created my calendar template with spaces for 5 weeks a month, but 2011 is unusual, and has months with dates in six weeks in a month, so this example shows six rows. When that is not necessary, the calendar will appear slightly larger when printed.
Now we will set up the columns for the day of the week. Each day will also use two columns, which makes a small box in the corner for each day. This will be easier to see once cell borders are in place.
Set column A to a width of ½ inch, Set column B to the same. This gives you a perfect square of 1 inch for each day, with an inset square box. Repeat the spacing for columns A and B across the spread sheet, for a total of seven sets. This will be columns A to N. Rather than setting the width for each column, highlight columns A and B and then click on the paste format option. The icon for this is a small brush. Highlight across to row N, and paste the format. Now you have set up the days of the week.