Understanding Printing Features

You can simply print your sheet, as described in Sending a Sheet to a Printer, or you can specify print options.

Most print options are set at the sheet level. When you print, you are sending a specified sheet to the printer, which uses those settings. If you want different print settings than the default settings, you much reset your print options before printing each sheet.

You can set print page margins, set the number to use to begin numbering the pages in the sheet, select the page orientation, and specify whether to print the sheet border, column and row headers, grid lines, colors, and shadow effect. You can specify the order in which pages are printed–down then across, or across then down. You can also specify header and footer text to appear on printed sheet pages. For instructions, see Specifying Print Options and Adding Header and Footer Text to Printed Pages.

You can print a portion of a sheet by specifying either a range of pages or a block of cells to print. Alternatively, you can print only the sheet columns and rows that contain data. You can also specify page breaks before columns or rows.

For instructions, see the following sections:

• Specifying a Print Range
• Printing the Portion of the Sheet with Data
• Specifying Print Page Breaks