Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Sheet

Specifies the elements to be included in the printout of all sheets with the current Page Style. Additionally, you can set the print order, the first page number, and the page scale.

To access this command...

Choose Format - Page - Sheet tab.

Print

Defines which elements of the spreadsheet are to be printed.

Column and row headers

Specifies whether you want the column and row headers to be printed.

Grid

Prints out the borders of the individual cells as a grid. For the view on screen, make your choice under Tools - Options - Office Calc - View - Grid lines.

Comments

Prints the comments defined in your spreadsheet. They will be printed on a separate page, along with the corresponding cell reference.

Objects/images

Includes all inserted objects (if printable) and graphics with the printed document.

Charts

Prints the charts that have been inserted into your spreadsheet.

Drawing Objects

Includes all drawing objects in the printed document.

Formulae

Prints the formulae contained in the cells, instead of the results.

Zero Values

Specifies that cells with a zero value are printed.

Page Order

Defines the order in which data in a sheet is numbered and printed when it does not fit on one printed page.

Top to bottom, then right

Prints vertically from the left column to the bottom of the sheet.

Left to right, then down

Prints horizontally from the top row of the sheet to the right column.

First page number

Select this option if you want this style to restart page numbering.

Enter the number you want to restart at.

Scale

Defines a page scale for the printed spreadsheet.

Scaling mode

Select a scaling mode from the list box. Appropriate controls will be shown below the list box.

Reduce/enlarge printout

Specifies a scaling factor to scale all printed pages.

Scaling factor

Enter a scaling factor. Factors less than 100 reduce the pages, higher factors enlarge the pages.

Fit print range(s) to width/height

Specifies the maximum number of pages horizontally (width) and vertically (height) on which every sheet with the current Page Style is to be printed.

  • The print ranges are always scaled proportionally, so the resulting number of pages may be fewer than specified.
  • You may disable one of the boxes, then the unspecified dimension will use as many pages as necessary.
  • If you disable both boxes, this will result in a scaling factor of 100%.
Width in pages

Enter the maximum number of pages to be printed horizontally across.

Height in pages

Enter the maximum number of pages to be printed vertically stacked.

Fit print range(s) on number of pages

Specifies the maximum number of pages on which every sheet with the current Page Style is to be printed. The scale will be reduced as necessary to fit the defined number of pages.

Number of pages

Enter the maximum number of pages to be printed.