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 main menu bar. Page break lines are
displayed on screen.
3) To check the print range, go to File > Page Preview on the main 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 main 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 main 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 main 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 main menu bar to open the Edit Print Ranges
dialog where you can define the print range.
146 | Getting Started with LibreOffice 4.0