Page Setup - Data Sheets

The Page Setup for data sheets is accessible via the print window (see Printing). For the spreadsheet module in ReliaSoft Workbooks, choose View > Print > Page Setup.

Maximize Printing Space

The following options are available on the Page tab or Margins tab of the Page Setup.

• Orientation. The Portrait orientation works best when the data has more rows than columns. If the data sheet is wider than it is tall, select the Landscape orientation.
• Scaling allows you to shrink the font size by a certain percentage to fit the data sheet into one page, or enlarge it to span the data sheet across multiple pages.
• Paper size and Print quality. The options depend on the type of printer you use.
• First page number allows you to specify any number to be the starting page number.
• Margins adjusts the widths of the margins on the paper.
• Center on page allows you to center the data sheet in the printout horizontally, vertically or both.

Print Order and Other Options

The Sheet tab of the Page Setup provides more printing options:

• Print area allows to specify a range of cells to print. Recommended if you want to print only a specific selection of data and not the entire data sheet. For example, you could enter the range A1:B10 to print only cells A1 through B10. To print the entire data sheet, clear this field.
• Print titles. If your data sheet is more than one page long, you can repeat row or column titles on each printed page to make it easier to read your data. For example, to repeat the column titles of a data table that has several rows spanning multiple pages, you could enter the range $1:$1 into the Rows to repeat at top field, where $1:$1 is the location of the column title in the table.
• Gridlines prints the gridlines of a data sheet.
• Draft quality prints the data sheet at a lower quality for faster printing.
• Row and column headings prints the row numbers and column headings of the data sheet.
• Comments. If you’ve added comments to the data sheet, you can choose to print them along with the data sheet. Choose whether to print the comments at the end of the sheet or as they are displayed in the sheet.
• Cell errors as allows you to specify how any cell errors in the data sheet should be displayed in the printouts. Choose whether to print them as displayed, <blank>, dashes (--) or as #/NA
• Page order. If your data sheet spans multiple pages, you can specify the order in which the pages are numbered and printed.
  • Down, then over prints from the top down, then left to right.
  • Over, then down prints from left to right, then from the top down.

Headers/Footers

The Header/Footer tab of the Page Setup provides several options for adding custom headers/footers to the printed page.

• Header and Footer drop-down lists allow you to select a predefined header/footer format. The software includes several predefined formats to choose from.
• Different odd and even pages and Different first page gives you the option to apply different headers/footers for odd and even pages, or choose to apply a different header/footer to the first page only. Select the check box for the desired option and then click the Custom Header/Footer button to edit the headers (see the section below). To apply the same header/footer to all pages in the document, clear the check boxes for both options.
• Scale with document auto-adjusts the font size to scale with the data sheet.
• Align with page margins auto-adjust the position of the header/footer to be consistent with the page margins.

Edit the Headers/Footers

You can edit the headers/footers for the current printing session. Note that the edits are discarded when you switch to different header/footer format or when you exit the print preview.

To edit an existing header/footer, choose it from the drop-down list and click the Custom Header/Footer button. Alternatively, you can select none from the drop-down list and then click the button.

To insert variable information such as date, time, number of pages, etc., use the command icons in the window to insert the appropriate field codes (or use the codes shown in the table below).

Format Code	Description
&[Page]	Inserts the page number.
&[Pages]	Inserts the number of pages.
&[Date]	Inserts date.
&[Time]	Inserts time.
&[Path]&[File]	Inserts the file path.
&[File]	Inserts the file name.
&[Tab]	Inserts the sheet name.
&[Picture]	Inserts a selected picture. Click the Format Picture icon on the Header/Footer window to set the image size and other properties.