Defining Print Ranges on a Sheet
You can define which range of cells on a spreadsheet to print.
The cells on the sheet that are not part of the defined print range are not printed or exported. Sheets without a defined print range are not printed and not exported to a PDF file, unless the document uses the Microsoft Excel file format.
For files opened in Microsoft Excel format, all sheets that do not contain a defined print range are printed. The same behaviour occurs when you export the Microsoft Excel formatted spreadsheet to a PDF file.
To Define a Print Range
-
Select the cells that you want to print.
-
Choose Format - Print Ranges - Define.
To Add Cells to a Print Range
-
Select the cells that you want to add to the existing print range.
-
Choose Format - Print Ranges - Add.
To Clear a Print Range
- Choose Format - Print Ranges - Clear.
Using the Page Break Preview to Edit Print Ranges
In the Page Break Preview, print ranges as well as page break regions are outlined by a blue border and contain a centred page number in grey. Non-printing areas have a grey background.
To define a new page break region, drag the border to a new location. When you define a new page break region, an automatic page break is replaced by a manual page break.
To View and Edit Print Ranges
- Choose View - Page Break Preview.
To change the default zoom factor of the Page Break Preview, double-click the percentage value on the Status bar, and select a new zoom factor.
- Edit the print range.
To change the size of a print range, drag a border of the range to a new location.
To delete a manual page break that is contained in a print range, drag the border of the page break outside of the print range.
To clear a print range, drag a border of the range onto the opposite border of the range.
- To exit the Page Break Preview, choose View - Normal.