Options

Use the Options page found in the worksheet's File | Page Setup to set gridlines, page order, and content of headers and footers on worksheet print outs.

Print Appearance

The Print group controls how the worksheet information is printed.

Check the Gridlines option to draw gridlines separating each column and row.
Check the Row and column headers option to print the column letters and row numbers of the worksheet.
If cells contain color backgrounds (set from the Format | Cell Properties command), use the Black and white option to print the worksheet in black-and-white on color printers.

Page Order

The Page Order group controls the order in which multiple pages are printed.

The Down and then across option prints the worksheet from top to bottom first and then moves to the right and prints top to bottom again.
The Across and then down option prints from left to right first and then moves down and prints left to right again.

Headers and Footers

The Header/Footer group controls the type of information included in the worksheet data print out. The Header appears at the top of the page, and the Footer appears at the bottom of the page. The header and footer are spaced from the edge of the page based on the From Edge option of the Margins tab. Descriptive text can be typed in the Header and Footer boxes, or click the arrows to the right of the boxes and click the items in the list. Currently, there are no header/footer options for the map window.

Automatic header/footer codes:

File Name ( < F> ) prints the name of the active file. The drive and path are not included.
Page Number ( <P> ) prints the page number for each page. When several pages are printed the order of printing is controlled from the Page Order option.
Total Page Count ( < C> ) prints the total number of pages that are required to print out the worksheet.
Current Date ( <D> ) prints the current date.
Current Time ( < T> ) prints the current time.
Left/Center/Right Separator (<&> ) separates the header and footer text so it is spread out across the page. Too many separators can actually push text off the page. If this happens remove the <&> separator and use spaces instead.

Examples

For a six page document, <&><&>Page <P> of < C> would print (on the right side of the first page):