5

Spreadsheet 7-21
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.
Important The examples in this documentation are based on U.S.
conventions. For example, dates and numbers are shown in U.S. formats. In
English-speaking countries other than the United States, functions, formulas,
and calculations might be formatted differently. For example, in the U.S.,
commas act as separators in formulas. In other countries, semicolons might
be used as separators.
Understanding formulas
Within a single formula, you can calculate a result using:
1 values, such as $4.95, Ms. Jane Smith, or February 2, 1997
1 operators, such as +, -, *, =, >, or ()
1 cell references, such as B2, P66, or D7
1 functions, such as =SUM(B2+N66) or =PRODUCT(A1..C1)
1 named ranges
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 or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,* see:
E printing, spreadsheets
E Set Print Range command
In the Help index,* see:
E spreadsheets, calculations