Here we’ll define a list with the months. The 1st sheet became “Month Calendar” and the second one, “Settings”. So I deleted the third sheet and renamed the first two. Those lines define the print area.īy default, OpenOffice creates three sheets in a new spreadsheet, but we only need two for this project. The default values are fine, but I decided to use “nicer” values.Īfter you click OK you might notice some darker lines in your spreadsheet. One more thing we need to do in this panel is to set the margins. I opted for “US Letter”, but you can choose A4 if that’s the standard in your country. In the “Page” tab change the paper format to the one you want.

That can be achieved by selecting Format from the menu and then clicking on Page…. To make sure our calendar will fit nicely on a sheet of paper when printed, we need to first update the default page settings. In the “Start Center” window click on “Spreadsheet” or from the menu select File -> New -> Spreadsheet.

ods files below:įor more styles and designs have a look at these printable calendars.īefore we get started, let me show you the result: If you’re just looking for an OpenOffice calendar template that you want to print, simply download download one of the. In this post I will share with you how to make an editable calendar template for OpenOffice in which you can simply change the month or the year and the entire calendar gets updated. This tutorial also includes a calendar template (.ods) How to create a calendar template in OpenOffice which can be updated dynamically with any year or month.

Openoffice calc enter new line in cell