User Manual

VIII AppleWorks 5 User’s Manual
Creating links in paint documents 6-14
Chapter 7: Spreadsheet
When to use a spreadsheet 7-1
Spreadsheet basics 7-2
Creating a spreadsheet 7-3
About the spreadsheet window 7-3
Working with spreadsheet frames 7-4
Typing in a spreadsheet 7-5
Selecting cells and ranges 7-5
Modifying cell data 7-6
Editing data 7-6
Moving data 7-7
Copying and deleting data 7-8
Filling a range of cells 7-8
Formatting cell data 7-9
Sorting cell data 7-11
Locking cell data 7-12
Naming cells and ranges 7-12
Assigning names to cells 7-13
Editing and deleting names 7-13
Using named cells in formulas 7-14
Replacing cell references with named cells 7-14
Example 1: Using cell names in a formula 7-15
Example 2: Replacing named cells with cell references 7-16
Changing cells, rows, and columns 7-16
Resizing or hiding rows and columns 7-16
Inserting and deleting cells, rows, and columns 7-17
Changing the number of rows and columns 7-18
Adding borders, colors, and patterns to cells 7-18
Locking row and column titles 7-19
Adding and removing page breaks 7-19
Changing the display 7-19
Printing a spreadsheet document 7-20
Working with formulas 7-20