beautypg.com

Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 8

background image

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