5
Table Of Contents
- Contents
- Chapter 1: Introduction
- Chapter 2: Creating, opening, and printing documents
- Starting AppleWorks
- Creating a document
- Saving a document
- Opening a document
- Finding documents
- Linking to other documents
- Saving document formatting as templates (stationery)
- Identifying your documents
- Protecting documents with passwords
- Importing and exporting documents
- Converting documents
- Closing a document and leaving AppleWorks
- Printing a document or Help topic
- Chapter 3: Basics
- Chapter 4: Text (word processing)
- When to use a word processing document
- Text basics
- Changing text appearance
- Changing paragraph formats
- Sorting paragraphs
- Outlining
- Creating tables
- Working with pages
- Dividing a document into sections
- Adding footnotes and endnotes
- Finding and changing text
- Using writing tools
- Adding pictures and frames to text
- Creating links in word processing documents
- Chapter 5: Drawing
- When to use a drawing
- Drawing basics
- Changing the appearance of objects
- Connecting objects
- Arranging objects
- Locking objects to prevent changes
- Creating a master page
- Adding pages to a draw document
- Creating custom colors, patterns, gradients, and textures
- Adding clip art
- Adding text, spreadsheet, or paint frames
- Creating links in draw documents
- Chapter 6: Painting
- Chapter 7: Spreadsheet
- When to use a spreadsheet
- Spreadsheet basics
- Modifying cell data
- Naming cells and ranges
- Changing cells, rows, and columns
- Adding and removing page breaks
- Changing the display
- Printing a spreadsheet document
- Working with formulas
- Cell references in formulas
- Working with functions
- Displaying data in charts (graphs)
- Adding pictures or a text frame
- Creating links in spreadsheet documents
- Chapter 8: Database
- When to use a database
- Database basics
- Example: Creating a simple database
- Designing a database
- Entering data in fields
- Duplicating, deleting, and moving records
- Moving through records
- Viewing records
- Playing movies in multimedia fields
- Working with rows and columns in List mode
- Selecting and hiding records
- Sorting records
- Finding information
- Working with layouts
- Changing the appearance of data
- Presenting and summarizing data with parts
- Creating reports
- Importing data from other documents
- Printing a database document
- Chapter 9: Beyond the basics
- Chapter 10: Communications
- Chapter 11: AppleWorks and the Internet
7-6 AppleWorks 5 User’s Manual
Modifying cell data
AppleWorks provides many ways to modify and correct your data.
Note You can’t edit, delete, or move data in locked cells. To unlock cells,
select the cells and then choose Unlock Cells from the Options menu.
Editing data
Edit data in the entry bar, or use AppleWorks commands to check spelling
or find and change cell data.
To Do this
Select a cell range Hold down the mouse button and drag the pointer over the cells
you want to select.
Select a cell range Hold down the mouse button and drag the pointer over the cells
you want to select.
Select an entire row
or column
Click the row or column heading.
Select the entire
spreadsheet
Choose Select All from the Edit menu.
Go to a cell Choose Go To Cell from the Options menu, type the cell address
(for example,
A42 or R7), and then click OK.
Go to a named cell or cell
range
Choose the name of the cell or range from the bottom of the
menu (in the entry bar). For more information, see “Naming
cells and ranges” on page 7-12.
*
Choose Index from the or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
To Do this
Edit the data in a cell Select the cell. In the entry bar, make your changes, and then
click to confirm the entry.
Move the insertion point
right or left in the entry bar
Click where you want the insertion point to be.
Address of
upper-left cell
in the selected
range
AppleWorks highlights
the selected cell range
Address of
selected cell
The selected cell has
a heavy border
In the Help index,* see:
E entering spreadsheet data
E finding text
E spelling
E spreadsheets, preferences










