CHouseLive

Excel 2003 - Printer Setup

Excel allows you to choose how you would like to print your sheet.

Click on File

1

Click on Page Setup

2

Page

3

There are 2 important settings on this page

Orientation

You can choose between Portrait and Landscape.

Scaling

If you want your workbook to print on a specific number of pages click the Fit to : box.

You can specify how many pages wide and tall you want the sheet to print on.

Click on Margins

4

You can specify the width of the Top, Left, Right and Bottom margins.

Centre on page

By clicking the Horizontally or Vertically boxes, the sheet will print on the centre of the page.

Click on Header/Footer

5

Excel has several preset Headers and Footers which you can access by clicking on the respective down arrows.

You can also insert a custom header or footer by clicking on the respective box.

Click on Sheet

6

There is one very useful setting on this tab.

Print titles

If you have a large sheet that spreads over more than one page, you might want the Row and Column Headings to print on each page, you will use this setting.

Click on the 7 button next to the Rows to repeat at top box.

This will take you back to your sheet, displaying the following box:

8

Click on the row you want to repeat on top of each page:

9

Click on the 10 button

You can follow the same procedure for a column you want repeated on a page.

When you are all done, click on the 11 button.

Copyright © CHouseLive - 2010 - All Rights Reserved