Page Setup Worksheet - Options

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

 

Options Page

Change page option properties in the Page Setup dialog Options page.

Print

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 with the Data Tools | Format | Format Cells 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 Across and then down option prints from left to right first and then moves down and prints left to right again.

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

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 page. Descriptive text can be typed in the Header and Footer boxes. Automatic text can be added to the Header or Footer boxes by clicking the arrows to the right of the boxes and clicking the items in the list.  

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):

Page 1 of 6

Enter Joe Smith<&>< F><&><D> to print out a name, file name, and date:

Joe Smith        COLORADO.DAT 01/05/10

To print centered text use the "&" operator one time, such as <&>< F>:

FILENAME.DAT

See Also

Page Setup - Worksheet

Page Setup - Margins

Page Setup - Page