beautypg.com

Naming cells and ranges – Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 146

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 Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a 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)