Defining a print range
Use this option to modify or set a defined print range. This could be useful if, in a large spreadsheet, you need to print only a specific area of data.
To define a print range:
Highlight the range of cells that comprise the print range.
Choose Format > Print Ranges > Define.
The page break lines will display on screen.
You can check the print range by using File > Page Preview. OOo will only display the cells in the print range.