beautypg.com

Locking cell data, Naming cells and ranges – Apple AppleWorks 5 : Mac OS User Manual

Page 158

background image

7-12

AppleWorks 5 User’s Manual

Locking cell data

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

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

*

Choose Index from the

or Help menu and scroll to the entry. Then choose a topic from

the list and click Go To Topic.

Before sorting

After sorting on first order key
A2, second order key B2, and
third order key C2

After sorting on first
order key (A2) only

In the Help index,

*

see:

E

locking

In the Help index,

*

see:

E

named cells and ranges

Cell B5 contains the
formula

=Shares*Price

instead of

=B3*B4

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)