Warning: This Help page is relevant to LibreOffice up to version 6.0.
For updated Help pages, visit https://help.libreoffice.org.

Print

From LibreOffice Help
Jump to: navigation, search

Determines the printer settings for spreadsheets.

Tools - Options - LibreOffice Calc - Print defines the settings for all spreadsheets. To define settings for the current document only, choose File - Print, then click the Options button.

Choose Tools - Options - LibreOffice Calc - Print

Pages

Suppress output of empty pages

Specifies that empty pages that have no cell contents or draw objects are not printed. Cell attributes such as borders or background colors are not considered cell contents. Empty pages are not counted for page numbering.

Sheets

Print only selected sheets

Specifies that only contents from selected sheets are printed, even if you specify a wider range in the File - Print dialog or in the Format - Print Ranges dialog. Contents from sheets that are not selected will not be printed.

Tip.png To select multiple sheets, click on the sheet names on the bottom margin of the workspace while keeping the Ctrl key pressed.