This is not a course. It is a... Tip Sheet

COMPUTER SKILLS AND TIP SHEETS
MS Excel 2002 - Printing

To preview before printing

With a spreadsheet you do not always print the whole document as you would in a word processor, for instance. You will quite often first select a part of a workbook and then choose to print that selected part. Furthermore, since a spreadsheet's workbook is an electronic sheet which is much bigger than an A4 piece of paper (as found in a printer), it is always advisable to first preview your print result before choosing to print the selection.

First Select that part of the workbook that you would like to print (see image below)

Click on File

Click on Print Preview

or

Click on the Print Preview icon 

The following page typically appears:

If the selected text appears on the preview screen and you are satisfied with the previewed result, click on the Print button.

However, with the above result, the fifth column does not appear on the page. One has several options for changing the page before printing.

  • change the margins
  • change the page orientation (portrait to landscape)
  • reduce the column widths
  • decrease the font size of data

To change the margin widths:

On the Print Preview page, click on the Margins button and move the mouse pointer  to the dotted lines representing the margins that you want to change. A double arrow    appears (circled in the image below). Press the left mouse button and keep it down. Drag the margin to the width you want.

pointer.jpg (769 bytes)

To change the page orientation:

Click on the Setup button, or choose Page Setup from the File menu.

Click on the white dot next to Landscape to turn the page orientation sideways (see below).

The resulting page is orientated sideways (we call this kind of orientation landscape and allows for the 5th column to be included on the page.

To print

If you have managed to do the Print Preview, this will be easy.

Select the area you want to print. If you want the whole data area of the workbook to be printed, you do not have to make a selection. Then...

Either

Click on the Print button on the Print Preview page

or

Click on File

Click on Print

or

Click on the Print icon 



                                           The Educators' Network



Copyright SchoolNet SA and SCOPE. All Rights Reserved.