nanaxtokyo.blogg.se

1. #HOW DO I NUMBER PAGES IN OPENOFFICE HOW TO#
2. #HOW DO I NUMBER PAGES IN OPENOFFICE UPDATE#
3. #HOW DO I NUMBER PAGES IN OPENOFFICE DOWNLOAD#

We have seven days in a week, so our calendar will be seven columns wide. We need figure out the width of the first seven columns. Remember, this calendar has to fit on a sheet of paper. I also merged the first 3 cells to have more space for the longer month names.īefore we add the year we need to do some work on the layout of the page. I chose to increase the font size to 40 and to make it bold. So since we have the month name section done, let’s style it. My approach to making this calendar is to style each part as soon as it’s ready. By clicking on that button you should see the drop-down list with all the months. Hit OK and you should see a button with an arrow pointing down next to the first cell. This gets all the cells starting from A1 to A12 in the “Settings” sheet. Then in the “Source” field we are going to write the formula that defines the range we want: $Settings.$A$1:$A$12. In the first tab, “Criteria”, choose “Cell Range” from the “Allow” options. Then, from the menu bar go to Data -> Validate….Ī panel called “Validity” should show up on the screen. Next, let’s switch back to the “Month Calendar” sheet and then select the first cell (A1). This list of month names will be used as the source for a drop-down in the first sheet. Technically, they can be written in any language, but for this tutorial I used English to keep things simple. 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….

#HOW DO I NUMBER PAGES IN OPENOFFICE UPDATE#

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:

#HOW DO I NUMBER PAGES IN OPENOFFICE DOWNLOAD#

If you’re just looking for an OpenOffice calendar template that you want to print, simply download download one of the.

#HOW DO I NUMBER PAGES IN OPENOFFICE HOW TO#

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.