\exporting;cells\\printing; cells\\ranges;print ranges\\PDF export of print ranges\\cell ranges; printing\\cells; print ranges\\print ranges\\clearing printranges\\defining;printranges\\extending printranges\\adding;cells in print ranges\\removing;print ranges\

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.

Note Icon

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.


To Define a Print Range

  1. Select the cells that you want to print.

  2. Choose \Format - Print Ranges - Define\.

To Add Cells to a Print Range

  1. Select the cells that you want to add to the existing print range.

  2. Choose \Format - Print Ranges - Add\.

To Clear a Print Range

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

  1. Choose \View - Page Break Preview\.

    Tip Icon

    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.


  2. Edit the print range.

    To change the size of a print range, drag a border of the range to a new location.

    Note Icon

    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.

  3. To exit the \Page Break Preview\, choose \View - Normal\.

Please support us!