Defining a print range
By default, if no print range has been defined, the entire contents of the worksheet will be printed. Optionally, a print range can be defined. Use this option to modify or set a defined print range. This could be useful if, in a large spreadsheet, only a specific area of data needs to be printed.
To define a print range:
- Highlight the range of cells that comprise the print range.
- Choose Format > Print Ranges > Define Print Range.
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.|
Adding to the print range
After defining a print range, you can add more cells to it. This allows you to print multiple, non-contiguous areas of the same sheet, while not printing the whole sheet. Once you have defined a print range:
- Highlight the range of cells that should be added to the print range.
- Choose Format > Print Ranges > Add Print Range.
This will add the extra cells to the print range.
The page break lines will no longer show up on the screen.
|The additional print range will print as a separate page, even if both ranges are on the same sheet.|
Removing a print range
It may become necessary to remove a defined print range, for example if the whole sheet needs to be printed at a later time.
To remove the print range, choose Format > Print Ranges > Clear Print Range.
This will remove all defined print ranges on the sheet.
After the print range is removed, the default page break lines will appear on the screen.
|Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).|