beautypg.com

Changing cells, rows, and columns – Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 150

background image

7-16

AppleWorks 5 User’s Manual

The formula contains the named cells Income and Expenses.

Example 2: Replacing named cells with cell references

This example shows you how to replace the named cells you defined in
Example 1 with cell references.

1.

Select cell B3 and choose Replace Names from the

menu in the entry bar.

2.

In the dialog box, note that Expenses and Income are suggested for replacement
with cell addresses. You want to replace them both, so click Replace.

The named cells are replaced with their corresponding cell addresses.

Changing cells, rows, and columns

There are several features that control how you display and work with data in
rows and columns. You can resize, hide, insert, and delete rows and columns.

Resizing or hiding rows and columns

To resize all the rows or columns in a range by the same amount, start by
selecting multiple rows or columns. Then specify a size or use the mouse.

To resize rows or columns by specifying a size, select the rows or columns
to change. Then choose Row Height or Column Width from the Format menu, type
a new measurement (type

0

to hide the row or column, or select Use default to

revert to the default row or column size), and then click OK.

*

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.

In the Help index,

*

see:

E

hiding

E

resizing, spreadsheet cells