Set-up the Page Options

Microsoft® Excel provides a number of optional settings to change the appearance of a printed page (change margins, adjust orientation, add headers/footers and modify other features). Before a document is printed, you should always ensure that the page is set up correctly by previewing the print job.

To change the Page Setup:

On the Page Layout tab, in the Page Setup Group, you can modify the following:

	Margins Icon	Change the distance between the edge of the page and the information being printed.
	Orientation Icon	Sets the paper orientation to Landscape or Portrait
	Paper Size Icon	Select the Appropriate paper size

In the Scale to Fit Group, you can modify the following:

	Scale Icon	Enlarge or reduce the printout from 10 to 400 percent of the original size.
	Height Icon	Specify exactly how many pages long you want the final printout
	Width Icon	Specify exactly how many pages wide you want the final printout.

In the Page tab

• Print quality – Specify the resolution (dots per inch) for printing. The higher the number, the better the quality – but it also takes longer.
• First page number – “Auto” will automatically start page numbering at the next sequential number.

Click on the Margins tab, and modify the following:

Margins tab

• Page Margins – Change the distance between the edge of the page and the information being printed.
• Header/Footer – Change the distance between the edge of the paper and the header and/or footer. Make sure that this value is smaller than the Top/Bottom margins or the header will overlap the data.
• Center on page – Centers the information Horizontally (between the left & right margins) or Vertically (between the top and bottom margins).

Click on the Header/Footer tab to customize or remove the headers/footers:

Header/Footer Tab

• The top section shows what the current header display, and the bottom section shows the current footer display.
• In the section called Header (Footer), there is a pull-down list of predefined headers (footers). Click on the down arrow Down arrow button and choose from the list of available headers.
• To customize your own header/footer click on the appropriate button:

Custom Footer button – Custom Header Button

Use the Left, Center and Right sections to type in the text to appear. What section the header/footer is typed in determines how the text will be justified on the page.

Header Window

You can also use the icons listed to create and edit your custom headers and footers:

Font dialog box icon Displays the font dialog box.

Current page number icon Inserts the current Page Number.

Total number of pages icon Adds the Total number of pages in the printout.

Date Icon adds the Date.

Time icon adds the Time.

Path and filename icon Inserts the Path and Filename of the active workbook.

Filename of active workbook icon Adds the Filename of the active workbook.

Name of active worksheet icon Adds the Name of the active worksheet.

Insert picture icon Allows you to insert a picture.

Sheet tab

• Print area – Specify the block to be printed. If a block of cells is selected prior to selecting this option, the print area will already be displayed.
• Print titles – This section allows you to specify rows to be printed along the top or the columns to be printed along the left of each page.
• Print -
  • Gridlines – suppress or print the sheet gridlines
  • Black and White – convert color images to black and white for faster printing
  • Draft Quality – speeds up the printout by printing fewer graphics and suppresses the gridlines
  • Row and Column Headings – print the row numbers and column letters around the border of the printout
  • Comments – include cell notes
  • Cell Errors – specifies the content printed in cells containing errors.
• Page order – Specify the order in which the pages will print.