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 the page order, details, and scale

To select the page order, details, and scale to be printed:

  1. Select Format > Page from the main menu.
  2. Select the Sheet tab.
  3. After making your selections (see next page), click OK.
The Sheet tab of the Page Style dialog

Page Order

You can set the order in which pages print. This is especially useful in a large document; for example, controlling the print order can save time if you have to collate the document a certain way.

Where a sheet prints to more than one page of paper, it can be printed either by column, where the first column of pages prints, and then the second column and so on, or by row as shown in the graphic on the top right of the page order dialog in Figure 3.


You can specify which details to print. Those details include:

  • Row and column headers
  • Sheet grid—prints the borders of the cells as a grid
  • Notes—prints the notes defined in your spreadsheet on a separate page, along with the corresponding cell reference
  • Objects and graphics
  • Charts
  • Drawing objects
  • Formulas—prints the formulas contained in the cells, instead of the results
  • Zero Values—prints cells with a zero value
Image:documentation_note.png Remember that since the print detail options are a part of the page’s properties, they are also a part of the page style’s properties. Therefore, different page styles can be set up to quickly change the print properties of the sheets in the spreadsheet.


Use the scale features to control the number of pages the data will print on. This can be useful if a large amount of data needs to be printed more compactly or, if the reader has poor eyesight, text can be enlarged when it prints.

  • Reduce/Enlarge printout—scales the data in the printout either larger or smaller. For example if a sheet would normally print out as four pages (two high and two wide), a scaling of 50% would print as one page (both width and height are halved).
  • Fit print range(s) on number of pages—defines exactly how many pages the printout will take up. This option will only reduce a printout, it will not enlarge it. To enlarge a printout, the reduce/enlarge option must be used.
  • Fit print range(s) to width/height—defines how high and wide the printout will be, in pages.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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