Choose between landscape and portrait.

Enlarges or reduces the worksheet or selection when you print so that it fits on the specified number of pages. Select the Fit to check box, enter a number in the page(s) wide by box, and enter a number in the tall box. To fill the paper width and use as many pages as necessary, type 1 in the pages(s) wide by box and leave the tall box blank.

Click Letter, Legal, or other size options to indicate the size you want your document or envelope printed.

Click the resolution you want to specify print quality for the active worksheet. Resolution is the number of dots per linear inch (dpi) that appear on the printed page. Higher resolution produces better quality printing in printers that support high-resolution printing.

Enter Auto to start numbering pages at "1" (if it is the first page of the print job) or at the next sequential number (if it is not the first page of the print job). Enter a number to specify a starting page number other than "1."

Enter a number in the Header or Footer box to adjust the distance between the header and the top of the page or between the footer and the bottom of the page. The distance should be smaller than the margin settings to prevent the header or footer from overlapping the data.

Center the data on the page within the margins by selecting the Vertically check box, the Horizontally check box, or both.

Click a built-in header in the Header box, and then click Custom Header to create a custom header for your worksheet. The built-in header is copied to the Header dialog box, where you can format or edit the selected header.

Click a built-in footer in the Footer box, and then click Custom Footer to create a custom footer for your worksheet. The built-in footer is copied to the Footer dialog box, where you can format or edit the selected footer.

Click the Print area box to select a worksheet range to print, and then drag through the worksheet areas that you want to print. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.

Select an option under Print titles to print the same columns or rows as titles on every page of a printed worksheet. Select Rows to repeat at top if you want specific rows as your horizontal title for each page. Select Columns to repeat at left if you want vertical titles on each page. Then on the worksheet, select a cell or cells in the title columns or rows you want. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.

Specifies what is printed from your worksheet, whether the printout is in color or black and white, and what the print quality is.

Click Down, then over or Over, then down to control the order in which data is numbered and printed when it does not fit on one page. The sample picture previews the direction your document will print when you choose one of these options.