beautypg.com

Printing a spreadsheet document, Working with formulas – Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 154

background image

7-20

AppleWorks 5 User’s Manual

Note

If the spreadsheet is in a frame, you must first open the frame before

changing the display. To open the frame, select the frame and choose Open Frame
from the Options menu. (See “Working with spreadsheet frames” on page 7-4.)

Printing a spreadsheet document

You can control various aspects of how your spreadsheet document prints.

Working with formulas

Use formulas to perform calculations on spreadsheet data. You can combine
numbers, cell references, named cells or ranges and functions (predefined
formulas) to build your formulas. For some simple formula examples, see
“Examples: Entering formulas” on page 7-25.

This option

Displays

Cell Grid

Dotted gridlines that separate the rows and columns

Solid Lines

The cell grid with solid gridlines (Cell Grid must be selected)

Formulas

Formulas (rather than computed values) in cells that
contain formulas

Column Headings
Row Headings

Column and row headings

Mark Circular References

Dots in cells that contain circular cell references (Formulas must
be deselected)

To print

Choose

Row and column titles on every page

Lock Title Position from the Options menu

The range of cells that you
specify, rather than all formatted
cells and cells that contain data

Set Print Range from the Options menu. In the
Print Range dialog box, click Print Cell Range, type
the range you want to print, and then click OK.

Row and column headings or the
cell grid

Click

on the Default button bar (or choose Print

from the File menu). In the dialog box, select or
deselect the Print Column Headings, Print Row Headings,
and Print Cell Grid checkboxes.

*

Choose Index from the Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a topic.

In the Help index,

*

see:

E

printing, spreadsheets

E

Set Print Range command