Apple AppleWorks 5 : Windows 95/NT 4.0 - Manual (Page 142)

7-8 AppleWorks 5 User’s Manual
Copying and deleting data
Copy and delete procedures are the same throughout AppleWorks. The
AppleWorks spreadsheet also provides other methods to copy and delete data.
Important When you cut or copy cells that are part of an absolute reference
in a formula, be sure to cut or copy the entire range of cells in the calculation.
Filling a range of cells
You can copy cell contents to adjacent cells and fill cells automatically with
patterns of data, such as the days of the week.
To copy cell contents—including formulas—into adjacent cells, drag to
select the cells with the data to duplicate and continue dragging down or to
the right over the cells you want to fill. Then choose Fill Down or Fill Right from
the Calculate menu.
To Do this
Copy or cut cell contents
and formatting Select the cells you want to work with. Then, on the Default
button bar, click
to copy or to cut (or choose Copy or
Cut from the Edit menu). You can also copy cell contents by
pressing Alt and dragging the cells to a new location on the
spreadsheet.
Copy only the value of a
cell that contains a formula Select the source cell or cell range, click on the Default
button bar (or choose Copy from the Edit menu), and then select
the target cell or range. Choose Paste Special from the Edit menu,
select Paste Values Only in the Paste Special dialog box, and then
click OK.
Paste cut or copied data Select the cell or cell range where you want the data to go, and
then click
on the Default button bar to paste (or choose
Paste from the Edit menu).
Delete the cell contents
and formatting Select the cells and choose Clear from the Edit menu.
Delete the cell contents and
retain the cell formatting Select the cells and press the Delete key.
* 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
entering spreadsheet data
In the Help index, * see:
E
filling cells