Excel 97 allows the user a great deal of flexibility in formatting printed output of worksheets.

Begin by setting up the page.

1. Select File => Page Setup from the menu bar. This will open a dialog box with multiple tabs. You will be on the "Page" tab.
   

2. Select the orientation of the page to print (portrait or landscape). For our example, let's choose "Landscape".

3. You can scale the size of your output so that it will print out on a specifed number of pages, or choose a relative size in %. To print full size, use the default selection of 100%. For our example, let's scale the output to 85% of normal.

4. Finally, choose the paper size you will be using.

5. Now, move to the "Margins" tab and apply the margins that you want. For our example, set the left and right margins to 0.75" and the top and bottom margins to 1.0". You can also set the page to center the printing output either vertically or horizontally or both.

6. Next, select the "Header/Footer" tab and set the Headers and Footers for the page. When viewing the Header/Footer tab, you will see a preview pane for the header and a preview pane for the footer. Under each preview pane is a drop-down box with an arrow which contains some commonly used headers and footers. Click on the arrow to choose from pre-defined headers and footers, or click on "Custom Header" or "Custom Footer" to define your own.

7. Last, set the print area from the "Sheet" tab, using the cell range notation. You can type in a cell range, or you can click on the worksheet button in the data entry cell to show the worksheet. Select the cells you wish to print.

8. By default, Excel will not print gridlines on your worksheet. If you want gridlines, check the "Gridlines" box in the "Print" section on the "Sheet" tab. Other options are available here as well.

At any time during the Page Setup process, you can click on the "Print Preview" button to see what your printed document will look like. This feature makes it easy to make changes to how your document is printed out before you actually produce hard copy. Once you have set up your page printout, you can print by selecting Print from the File menu, or by pressing the Print button in the toolbar.