Calc Guide - Chapter 6 - Printing, Exporting, and E-mailing

Sep 22, 2026

Upload by Aladdin

Calc Guide Chapter 6 explains how to print spreadsheets, control printing behavior, and select the exact pages or sheet ranges to output. It covers setting general printing options, defining and editing print ranges, managing page/row/column breaks, and configuring headers and footers through page styles. The chapter also guides exporting Calc documents to PDF with quick export, PDF content and quality controls, and options dialogs. A note for Mac users lists key substitutions for menu and keyboard commands.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages22

Reading Time55 min

AccessFree to download

Quick printing

Controlling printing

Selecting general printing options

Printing multiple pages on a single sheet of paper

Selecting sheets to print

Using print ranges

Defining a print range

Adding to the print range

Removing a print range

Editing a print range

Printing rows or columns on every page

Defining a custom print range

Page breaks

Inserting a page break

Row break

Column break

Deleting a page break

Printing options setup in page styles

Headers and footers

Setting a header or a footer

Header or footer appearance

Setting the contents of the header or footer

Exporting to PDF

Quick export to PDF

Controlling PDF content and quality

General page of PDF Options dialog

Initial View page of PDF Options dialog

Calc Guide Chapter 6 Printing, Exporting, and E-mailing This document is Copyright © 2005–2011 by its contributors as listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License ([http://www.gnu.org/licenses/gpl.html](http://www.gnu.org/licenses/gpl.html)), version 3 or later, or the Creative Commons Attribution License ([http://creativecommons.org/licenses/by/3.0/](http://creativecommons.org/licenses/by/3.0/)), version 3.0 or later. All trademarks within this guide belong to their legitimate owners. Contributors Barbara Duprey Feedback Please direct any comments or suggestions about this document to: [documentation@libreoffice.org](documentation@libreoffice.org) Acknowledgments This chapter is based on Chapter 6 of [the](the OpenOffice.org 3.3 Calc Guide. The)[ OpenOffice.org 3.3 Calc Guide](the OpenOffice.org 3.3 Calc Guide. The)[. The](the OpenOffice.org 3.3 Calc Guide. The) contributors to that chapter are: Jean Hollis Weber Shelagh Manton Emma Kirsopp Kashmira Patel Peter Kupfer Linda Worthington Publication date and software version Published 15 April 2011. Based on LibreOffice 3.3. Note for Mac users | Some keystrokes and menu items are different on a Mac from those used in Windows and Linux. The table below gives some common substitutions for the instructions in this chapter. For a more detailed list, see the application Help. | | | | --- | --- | --- | | Windows/Linux | Mac equivalent | Effect | | Tools → Options menu | LibreOffice → | Access setup options | | selection | Preferences | | | Right-click | Control+click | Open context menu | | Ctrl (Control) | z (Command) | Used with other keys | | F5 | Shift+z+F5 | Open the Navigator | | F11 | z+T | Open Styles & Formatting window | [Documentation for LibreOffice is available at](Documentation for LibreOffice is available at www.libreoffice.org)[ www.libreoffice.org](Documentation for LibreOffice is available at www.libreoffice.org) Copyright......................................................................................................................................... 2 Note for Mac users........................................................................................................................... 2 Quick printing................................................................................................................................... 4 Controlling printing........................................................................................................................... 4 Selecting general printing options................................................................................................ 5 Printing multiple pages on a single sheet of paper...................................................................... 5 Selecting sheets to print.............................................................................................................. 6 Using print ranges............................................................................................................................ 7 Defining a print range.................................................................................................................. 7 Adding to the print range............................................................................................................. 7 Removing a print range............................................................................................................... 7 Editing a print range.................................................................................................................... 7 Printing rows or columns on every page...................................................................................... 8 Defining a custom print range...................................................................................................... 9 Page breaks...

FAQs

What topics are covered in Calc Guide Chapter 6?

It covers quick printing, controlling printing options, selecting sheets and print ranges, using page/row/column breaks, configuring headers and footers, and exporting to PDF including quality and content controls.

How do print ranges work in this chapter?

The chapter explains how to define, add to, remove from, and edit print ranges, and how to use both fixed and custom print range selections.

What does the chapter say about exporting to PDF?

It describes quick export to PDF and how to control PDF content and quality using PDF Options dialogs, including the General page and Initial View page.

Sep 22, 2026

Upload by Aladdin