Directions: Click on the Page, Margins, Header/Footer or Sheet tab on any image to see what each tab looks like, along with a brief summary of the faetures offered.

Page Tab

This tab is where you will find options such as Page Orientation, Scaling and Paper Size.

Page Orientation determines if your sheet will print width-wise (Landscape) or lengthwise (Portrait).

Scaling lets you make the sheet print at a larger or smaller scale. It will also let you shrink the sheet to fit a specified number of pages by selecting Fit to.

Cell Formats
[Close Window | Menus]

Margins Tab

You can set margin widths and height under this tab, and you can also set them by dragging them in the Print Preview window.

Another useful option in this tab are the checkboxes at the bottom that allow you to center on page what you print out either Horizontally, Vertically or both.

Cell Formats
[Close Window | Menus]

Header/Footer Tab

The Header prints at the top and the Footer prints at the bottom of every page.

You can choose a basic header or footer by selecting them from the menus, which are labeled (none) in the picture, or create a custom header or footer by clicking on the corresponding button.

Cell Formats
[Close Window | Menus]

Sheet Tab

The sheet tab has more options than any of the other tabs.

The section that you want to print is indicated beside Print area, and this can be determined here or via the File menu in Excel.

Print titles lets you have certain rows repeat at the top or left of every page. This is especially useful for long lists, where the headings are at the top, but you want them to appear on every page.

There is a section labeled Print that is lets you select whether you want gridlines, row and column headings, etc. to print.

The last section, Page order, lets you choose the order in which sheets that are multiple pages long and wide will print out. It has a handy picture beside it that changes to illustrate what the options mean.

Cell Formats
[Close Window | Menus]
 

©2001, Kevin Pedersen