Operation Manual

Printing
Printing from Calc is much the same as printing from other LibreOffice components (see Chapter
10 Printing, Exporting, and Emailing in this guide). However, some details for printing in Calc are
different, especially regarding preparation for printing.
Print ranges
Print ranges have several uses, including printing only a specific part of the data or printing
selected rows or columns on every page. For more information about using print ranges, see the
Calc Guide Chapter 6 Printing, Exporting, and E-mailing.
Defining a print range
To define a new print range or modify an existing print range:
1) Select the range of cells to be included in the print range.
2) Go to Format > Print Ranges > Define on the Menu bar. Page break lines are displayed
on screen.
3) To check the print range, go to File > Page Preview on the Menu bar or click on the Page
Preview icon . LibreOffice will display the cells in the print range.
Adding to a print range
After defining a print range, you can add more cells to it by creating another print range. This
allows multiple, separate areas of the same sheet to be printed while not printing the whole sheet.
1) After defining a print range, select an extra range of cells for adding to the print range.
2) Go to Format > Print Ranges > Add on the Menu bar to add the extra cells to the print
range. The page break lines are no longer displayed on the screen.
3) To check the print ranges, go to File > Page Preview on the Menu bar or click on the Page
Preview icon . LibreOffice will display the print ranges as separate pages.
Note
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 later.
To remove all the defined print ranges, go to Format > Print Ranges > Remove on the Menu bar.
After the print ranges have been removed, the default page break lines will appear on the screen.
Editing a print range
At any time, you can directly edit the print range, for example to remove or resize part of the print
range. Go to Format > Print Ranges > Edit on the Menu bar to open the Edit Print Ranges
dialog where you can define the print range.
Chapter 5 Getting Started with Calc | 151