Apple M9057 User Manual - Page 167
Printing a spreadsheet document, Working with formulas, Understanding formulas
UPC - 718908500040
View all Apple M9057 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 167 highlights
Spreadsheet 7-21 Printing a spreadsheet document You can control various aspects of how your spreadsheet document prints. In the Help index,* see: E printing, spreadsheets E Set Print Range command To print Row and column titles on every page The range of cells that you specify, rather than all formatted cells and cells that contain data Row and column headings or the cell grid Choose Lock Title Position from the Options menu 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. 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. 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 In the Help index,* see: E spreadsheets, calculations 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 * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.