Printing the spreadsheet

To print the spreadsheet, click on the Print button image\print.gif on the toolbar or select the Print command from the File menu. The "Print" dialog box is displayed.

The active printer is displayed at the top of the dialog box. To change this, click on the arrow at the right of the Name box and scroll through till you find the printer you want.

In the Print range group box, you can specify how much of the spreadsheet you want to print:

In the Print what group box, specify:

Check the Print To file box to create a new file on disk, instead of sending the document to the printer. You will be prompted to give the file a name.

Type the number of copies you require in the Number of copies box and leave the Collate box checked if you want the pages to be printed in sequence (rather than all page 1s, then all page 2s, and so on).

If you want to select further properties specific to the printer, click on the Properties button. The properties are printer dependent and therefore vary from printer to printer.

When all is set, click on the OK button and the printing process will commence. There will be a pause while the information is sent to the printer, and then the physical printing will begin. Ability will divide your spreadsheet into pages, left to right and top to bottom. If you find, for example, that page 2 and 4 print out with a single column, and you really wanted to fit the entire spreadsheet onto two pages, either reduce the width of one or more columns or reduce the left and right margins (and then check with print preview).

 

For more options, see also: Printer options