Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Selecting sheets to print

You can select one or more sheets for printing. This can be useful if you have a large spreadsheet with multiple sheets and only want to print certain sheets. For example, an accountant might record costs over time with one sheet for each month. To print the November and December sheets, follow this procedure.

  1. Go to the November sheet. Hold down the Control key and click on the tab of the December sheet.
  2. Image:documentation_caution.png If you keep the selected sheets selected, when you enter data on one sheet, you enter data on all sheets at the same time. This might not be what you want.
  3. If you wish to print all of the sheets, go to File > Print and select Options.
  4. Image:documentation_note.png The Options button is different from the Properties button. Properties deals with the settings of the printer, whereas Options deals with OOo’s settings.
  5. Uncheck Print only selected sheets. This affects the print preview, export, and printing of your spreadsheet.
  6. Click OK.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire