/text/scalc/guide/printranges.xhp exporting;cells printing; cells ranges;print ranges PDF export of print ranges cell ranges; printing cells; print ranges print ranges clearing, see also deleting/removing defining;print ranges extending print ranges deleting;print ranges mw deleted "adding;" and corrected two typos in "defining;" and "extending.." MW changed "clearing," 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 Excel file format. For files opened in Excel format, all sheets that do not contain a defined print range are printed. The same behavior occurs when you export the Excel formatted spreadsheet to a PDF file.UFI: New, see spec "Calc Print Settings Sheet Property "Print Entire Sheet"" 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 - Remove. 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 centered page number in gray. Nonprinting areas have a gray 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.

Editing Print Ranges