Le Moyne College CSC-151 Microsoft Excel 2003 Reference

• Change the page orientation (portrait or landscape)
• Change the scaling using either a percentage or to fit a certain number of pages.
• Change the paper size or quality.
• Change the starting page number.

• Change the margins along any of the four paper edges.
• Indicate that the page should be centered horizontally, vertically, or both.

Two different menu items will bring up the Page Setup dialog box:

• View, Header and Footer...
• File, Page Setup..., then click on the Header/Footer tab

You have two ways to create a header or footer

1. Select a predefined header or footer from the appropriate dropdown list.

The predefined headers and footers provide a list of pre-formatted information, including workbook name, worksheet name, author name, and page number.

2. Click on the Custom Header... or Custom Footer... button to display the appropriate dialog box.

The Header dialog box shown to the right illustrates how you would create a custom header. You have the choice of placing information in the header so that it is left aligned, centered, or right aligned. The buttons found immediately above the three sections allows you to add certain types of information, including (from left to right) specifying font attributes, page number, number of pages, date, time, path & file name, file name, worksheet name, picture, and fill effects

The Footer dialog box provides the same capabilities as the Header dialog box.

• Specify the rows and columns that you want to print (i.e., print area).

This is useful when you do not want to print all of the information on a worksheet.

• Specify the rows to repeat at the top of every printed page.
• Specify the columns to repeat on the left of every printed page.
• Optionally print:

• gridlines - light grade borders around each cell.
• black and white - even though the worksheet may use colors. Note that this is really using a grayscale.
• draft quality.
• row and column identifiers (numbers and letters).
• any comments that are on the worksheet.
• Specify the order in which the pages are printed.