[. . . ] AppleWorks 5 User's Manual
Includes instructions for using your software
FOR MAC OS
K Apple Computer, Inc.
© 1998 Apple Computer, Inc. Under the copyright laws, this manual may not be copied, in whole or in part, without the written consent of Apple. Your rights to the software are governed by the accompanying software license agreement. The Apple logo is a trademark of Apple Computer, Inc. , registered in the U. S. [. . . ] Then choose a topic from the list To
7-12 AppleWorks 5 User's Manual
Before sorting
After sorting on first order key (A2) only
After sorting on first order key A2, second order key B2, and third order key C2
Locking cell data
In the Help index, * see: E locking
Protect data or formulas from accidental changes by locking cells. To lock a cell or a range of cells, select the cells, then choose Lock Cells from the Options menu. To unlock a protected cell or cell range, select the cells and then choose Unlock Cells from the Options menu.
Naming cells and ranges
In the Help index, * see: E named cells and ranges
You can assign a name to any cell or range of cells. Naming cells can help you:
1 remember the purpose of data in a particular cell or range 1 visually locate a named cell or range 1 simplify formulas by using named cells instead of cell addresses
When you select a named cell or range, you see its name here (you must select every cell in a range to see that range's name) Cell B5 contains the formula =Shares*Price instead of =B3*B4
* Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.
Spreadsheet 7-13
Assigning names to cells
To name cells, choose commands from the .
To Do this
menu in the entry bar
Example
Name a cell or cell range
Select the cells to name and choose Define Name from the menu. Type a name in the dialog box, and then click Define.
Cell A1 is unnamed
Cell A1 is named Revenue
Name cells or ranges using Select all of the cells to row and column titles name (include both row and you've already typed column headings in the selection) and choose Auto Name from the menu in the entry bar. You can assign more than one name to a cell or range.
Cells B3 and C3 are named Shares Cells B4 and C4 are named Price Cells B3 and B4 are named January Cells C3 and C4 are named February
In the Help index, * see: E named cells and ranges
Note Some characters, such as operators (like + or ÷ ) and punctuation
marks cannot be included in a cell name. For complete information about naming a cell, see onscreen Help.
Editing and deleting names
If you change your mind about the name or location of a named cell or range, or if you want to delete a name, choose Edit Names from the menu in the entry bar. Then, make changes in the Edit Names dialog box.
To Select a name from the scrolling list, and then
Rename a cell or range Change the cell address referenced by a name
Type a new name, and then click Modify Type a new address for the cell or range, and then click Modify
Delete the name of a cell or Click Remove. range If the name you want to delete is used in a formula, you must first replace the names in the formula with cell references. (See "Replacing cell references with named cells" on page 7-14. )
Index from or * Chooseand click Gothe Topic. Then choose a topic from the list To
7-14 AppleWorks 5 User's Manual
Note When you edit a name, AppleWorks updates all of the formulas that
use the name you edited.
Using named cells in formulas
In the Help index, * see: E formulas, spreadsheet E named cells and ranges
Once you've named cells and ranges, you can use the names in place of cell addresses in formulas. You can also use a name in a formula before it has been defined to refer to a particular cell or range. (For information on entering formulas, see "Working with formulas" on page 7-21 and onscreen Help. )
To Do this
Use named cells or ranges in a formula
Select a cell and begin typing the formula. Then, add named cells or ranges where you would normally add cell and range addresses. To add a named cell or range to a formula, choose the name from the menu in the entry bar. (You can also type the name directly into the formula. )
Enter named cells or ranges in a formula before you define the names Assign a name to a cell or range
Select a cell and begin typing the formula. Then type the name you want to define, and finish entering the formula. in the cell (because you haven't assigned the name to any cells yet). Select the cell or range to name and choose Define Name from the menu in the entry bar. In the Define Named Range dialog box, choose a name from the pop-up menu, and then click Define.
Replacing cell references with named cells
You can replace named cells or ranges (such as Shares or Price) with cell addresses (such as A5 or B1. . B3) in a formula. To replace cell addresses with named cells or ranges in a formula, choose Replace References from the menu in the entry bar.
To Do this
Replace named cells with cell addresses in formulas
Select the cell or range that holds the formula you want to work with. [. . . ] See Labels Make Table Assistant 2-6, 4-19 Making tables 2-6 Margins See also Indenting setting 3-18 viewing 3-12, 3-18 Master pages 5-17 Matching records 8-27 Memory 6-16 Merging data 7-5, 9-229-25 Microsoft Works, importing from 8-39 Modems described 10-2 phone calls and 10-4 requirements for 10-9 setting connection with 10-4 when required 10-1, 10-4 Modes, paint 6-7, 6-13 Mouse control preferences 3-22 Movies 8-9, 9-32 control badge 9-32 QuickTime extension 9-31 Moving database columns and rows 8-20 fields 8-32 records 8-16 images 6-8 objects 5-8 outline topics 4-17 spreadsheet cells and data 7-7
*Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.
I-8 AppleWorks 5 User's Manual Multimedia fields attributes, changing 8-34 described 8-9 moving with database document 8-17 Squares, drawing arranging 5-15 borders of 5-3, 5-10 changing appearance of 5-9 orientation of 5-15 coloring 5-10 connecting 5-14 copying attributes of 5-11 one or more 5-9 deleting 5-9 described 5-3 drawing tools 5-4 duplicating 5-9 filling 5-10 grouping and ungrouping 5-15, 5-16 inserting in text 4-34 locking and unlocking 5-16 moving 5-8 pasting 3-10 reshaping or smoothing 5-13 scaling 5-12 selecting 5-6 selection preferences 3-22 storing in libraries 3-18 Online service 10-2 Onscreen Help. See Help Opaque paint mode 6-7, 6-13 Opening button bar 3-6 documents AppleWorks 2-10 Assistants 2-4 from different applications 2-18 linked 9-3 new 2-2 stationery (templates) 2-7 HTML files 11-10 libraries 3-19 palettes fill and pen 5-9 library 3-19 links 9-2 mail merge 9-24 stylesheet 9-5 Operators 7-23, 8-25 Options stationery 2-13 Order keys 7-11 Outdenting (indented paragraphs) 4-11 Outline styles 4-19, 9-7 Outlines 4-144-18 Ovals, drawing 5-4 See also Objects Overlapping document windows 3-3 images 6-2, 6-7 objects 5-15, 6-2
N
Name fields 8-8, 8-14, 8-23 Named cells 7-12 cells in formulas 7-14 search 8-26 Naming cells 7-13 documents 2-9 fields 8-3, 8-12 layouts 8-30, 8-33 reports 8-38 searches 8-26 sort sequences 8-22, 8-23 Negative numbers entering 7-5 formatting 7-10 New documents, creating 2-2 Newsletter Assistant 2-6 Non-breaking space 4-5 Number fields 8-8 Numbering footnotes 4-28 outlines 4-15, 4-17 pages 3-16 paragraphs 4-11 sections 4-27 Numbers entering in spreadsheets 7-5, 7-10 formatting, in databases 8-20, 8-34 spreadsheets 7-10 sorting paragraphs by 4-14
P
Page view 2-21, 3-12 Pages adding to draw documents 5-18 breaking, in documents database 8-37 spreadsheet 7-20 word processing 4-23 counting 4-33 displaying in word processing documents 4-23 going to 3-3 margins and guides for, showing/ hiding 3-12, 3-18 master 5-17 numbering 3-16 orientation and size of 2-21, 3-18 title 3-15, 4-21 viewing in page view 3-12 Paint bucket 6-5 Paint documents See also Paint frames book marks in 6-17 creating 6-2 custom icons for 6-16 described 1-10, 6-3 linked frames in 9-30 links to different or same document 6-17 memory for 6-16 modes for 6-7, 6-13 painting in 6-4 pictures in 6-15 preferences for 3-21 previewing 6-16 resizing 6-16 resolution and depth 6-15 slides in 9-19
O
Objects See also Arcs; Bezigons; Circles, drawing; Freehand objects; Lines; Polygons; Rectangles, drawing; Regular polygons; Rounded rectangles, drawing;
*Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.
Index I-9 text and spreadsheets in 6-14 tools, using in 6-4 when to use 6-1 zooming images in 6-10 Paint frames See also Frames; Paint documents book marks in 6-17 creating in any document 6-2 draw documents 5-20 spreadsheet documents 7-34 word processing documents 4-34 described 6-3 linking 9-29 links to different or same document 6-17 opening and closing 6-4 painting in 6-4 point of origin 6-4 resizing 6-4 Painting tools 6-5 Paintings and drawings, differences between 6-2 Palettes See also Colors; Gradients; Patterns; Textures described 3-8 fill and pen 5-9, 6-6 library 3-18 links 9-2 mail merge 9-24 preferences for 3-22 stylesheet 9-5 Pane controls 3-1 Pane, scrollback 10-5 Paragraph Sorter Assistant 2-6, 4-14 Paragraph styles 9-7, 9-13 Paragraphs adding bullets, numbers, or checkboxes to 4-11 aligning text in 4-12 copying ruler settings for 4-14 counting 4-33 indenting 4-11 line spacing, changing 4-8 reordering 4-12 sorting 2-6, 4-14 space between 4-13 styles for 9-7, 9-13 Parts, database copying summary fields in 8-37 deleting and resizing 8-37 described 8-36 inserting 8-36 Passwords opening protected documents 2-10 setting 2-17 Paste Function button 7-27 Pasting See also Copying; Cutting cell data 7-8 formats 7-10 described 3-10 formats cell 7-10 paragraph 4-14 library items 3-20 objects 5-9 objects in a spreadsheet cell 3-10 styles 9-17 text from communications documents 3-10 Patterns See also Palettes changing in charts 7-33 copying from objects 5-11 setting for database fields 8-34 images 6-6 objects 5-10 Pencil 6-5 Perspective, adding to images 6-11 Phone book (communications) 10-3, 10-8 Pick Up command 6-13 Picture clippings 3-11 Pictures adding to database fields 8-9, 8-14 database layouts 8-33 drawings 5-19 headers and footers 3-14 HTML files 11-5 libraries 3-18 paintings 6-15 spreadsheets 7-33 word processing documents 4-34 formatting, in database fields 8-34 inline 4-34 wrapping text around 4-35 Pixels changing size of 6-15 described 6-1, 6-15 editing individual 6-10 Point of origin, for paint frames 6-4 spreadsheet frames 7-4 Pointer. [. . . ]