Inserting and deleting cells, rows, and columns, Changing the number of rows and columns – Apple AppleWorks 5 : Mac OS User Manual

Page 164

Advertising
background image

7-18

AppleWorks 5 User’s Manual

Inserting and deleting cells, rows, and columns

Important When you delete a cell, column, or row, you also delete its data.

To insert or delete an entire row or column, click one or more headings to
select rows or columns, and then on the Default button bar, click

to insert

cells or click

to delete cells. You can also choose Insert Cells or Delete Cells

from the Calculate menu.

To insert or delete a few cells, make a selection before you choose
Insert Cells or Delete Cells. In the dialog box, specify how you want existing cells
to be shifted, and then click OK.

Changing the number of rows and columns

A new spreadsheet contains 500 rows and 40 columns. A new spreadsheet
frame contains 50 rows and 10 columns.

*

Choose Index from the

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

the list and click Go To Topic.

To

Do this

Change the number of rows and
columns in a spreadsheet

Choose Document from the Format menu, type
numbers for Columns Across and Rows Down, and then
click OK.

Open a spreadsheet frame so that you
can change the number of rows and
columns in the spreadsheet

Select the frame and choose Open Frame from the
Window

menu. When you open the frame, you see

the spreadsheet in a new window. The open frame is
linked to the original document. Any changes you
make in the open frame are also made in the
document. To close the spreadsheet frame, choose
Close from the File menu.

Resize a spreadsheet frame to display
more cells

Select the frame and then drag a handle.

In the Help index,

*

see:

E

spreadsheets, arranging

Select the cells to

delete

The cells below are

shifted up

In the Help index,

*

see:

E

Document command

E

frames, formatting

E

opening

Advertising