Openoffice Calc question (mouse, screens, remove, display)

[rebellious1]

I'm trying to print the header and October section of the spreadsheet. When I define the print ranges, it places the "header" on the first page and the October section on the second page. How do I get all the information on 1 page? The header is acting like a page break I believe but I am unable to remove it.

[reed303]

What you are looking for is called "Rows to Repeat" under the Edit button in the "Print Ranges" pulldown.

First set the range for October, then add the header Row(s) to repeat

This from the Help screens:

"Rows to repeat

Choose one or more rows to print on every page. In the right text box enter the row reference, for example, "1" or "$1" or "$2:$3". The list box displays -user defined-. You can also select -none- to remove a defined repeating row.
You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the Rows to repeat text field in the dialog."

[rebellious1]

Originally Posted by reed303

what you are looking for is called "rows to repeat" under the edit button in the "print ranges" pulldown.

First set the range for october, then add the header row(s) to repeat

this from the help screens:

"rows to repeat

choose one or more rows to print on every page. In the right text box enter the row reference, for example, "1" or "$1" or "$2:$3". The list box displays -user defined-. You can also select -none- to remove a defined repeating row.
You can also define repeating rows by dragging the mouse in the spreadsheet, if the cursor is in the rows to repeat text field in the dialog."

thank you!