How Do I Create a Calendar in OpenOffice?

By Laurel Storm

Like its cousin Microsoft Excel, the Calc spreadsheet program included in the Apache OpenOffice 4.1.1 software suite can be used to create a printable calendar. The trick lies in resizing columns and rows to make the most out of the available space and then formatting cells to create a coherent design.

Step 1

Hold down the "Shift" key and then click cell G1 to select the first seven cells in the first row and then enable the "Merge Cells" check box to merge them into a single one.

Step 2

Click the "+" icon by the "Number Format" header to unfold that section of the menu, if it's not already visible, and then click the "ABC" button to set the cell's formatting to plain text.

Step 3

Type the name of the month in the cell -- if you like, you can also add the year. Decide whether you want the week to start with Sunday or Monday. Type that day of the week into cell A2, followed by the rest of the days, in order, in cells B2 to G2.

Step 4

Find out what day the first day of the month falls on and type the number "1" in the corresponding cell in the third row. For example, January 1, 2015 is a Thursday, so you would type "1" in cell D3. Continue entering numbers into cells, moving to a new row when you reach the end of a week, until you've completed the whole month. If you like, add numbers to represent the end of the previous month and the beginning of the following month to complete the first and last week.

Step 5

Click the "Page Preview" button to enter page preview mode. If you want your calendar print in landscape mode, click the "Format Page" button, select the "Paper" tab, select the "Landscape" radio button and click "OK." Click the "Page Preview" button again to return to normal mode. Entering and exiting page preview mode displays slightly thicker lines on the spreadsheet at the points where one page will end and the next will begin if you print out the calendar. If the vertical page break appears immediately after the last column of your calendar, skip the next step.

Step 6

Click "Format," hover over "Column" and select "Width." Make a note of the value that appears in the "Width" field and click "OK." Count the number of columns before the vertical page break, multiply that number by the value you found in the previous step and then divide the result by seven.For example, if the value in the "Width" field were 2.27 and your spreadsheet had 11 columns before the vertical page break, your calculation would be:(2.27 * 11) / 7 = 3.56Select the first seven columns of your spreadsheet, click "Format," hover over "Column" and select "Width" again. Enter your final result in the "Width" field and then click "OK." This sets all seven columns of your calendar to the same width without making them either too wide or too narrow -- unfortunately, OpenOffice Calc has no way of doing this automatically, so you have to do the calculations manually.

Step 7

Adjust the first two rows of your calendar to the desired height. Do this either by simply dragging the row divider or, if you'd rather be precise, by selecting the rows, clicking "Format," hovering over "Row," selecting "Height," entering a value and clicking "OK."

Step 8

Select the remaining rows of your calendar. Count the number of rows before the horizontal page break and subtract two from that number. Click "Format," hover over "Column" and select "Height." Multiply the value in the "Height" field by your result and then divide it by the number of rows you selected.For example, if the height value is 0.45, your result is 32 and you have selected 5 rows, your calculation will be:(0.45 * 32) / 5 = 2.88Enter the resulting value in the "Height" field and click "OK." This ensures the rows of your calendar that represent the weeks are of a consistent height and take up the remaining space on the page.

Step 9

Adjust the formatting for each of the cells using the various settings in the right-hand pane to get the desired look for your calendar. Once you're done, repeat the process to create the remaining months.

Tips & Warnings

  • If the right-hand pane is not visible, click "View" and select "Sidebar" to display it.
  • To save time when setting up the remaining months, duplicate the first sheet. Right-click the "Sheet 1" tab and select "Move/Copy Sheet." Ensure the "Copy" check box is enabled, select "Sheet 2" from the "Insert Before" list and then click "OK." This creates an identical copy of the first sheet. Repeat this process 10 more times and then modify each sheet to contain the correct information for one of the months in the year.
  • If you prefer, you can download and edit a template (see Resources) instead of creating your calendar from scratch.

References & Resources