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.
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.