Copying and deleting data, Filling a range of cells – Apple AppleWorks 5 : Mac OS User Manual
Page 154
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
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 Option 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.
Place a copy of cell contents
on the desktop or in another
document using drag and
drop (if you have Mac OS
drag and drop installed on
your system)
Select the cells and drag them to another document or to the
desktop. (When you drag cells to the desktop, you see a text
clipping.) To insert a text clipping into a spreadsheet
document, drag the text clipping from the desktop to a cell on
the spreadsheet.
For more information, see “Copying objects using the drag and
drop feature” on page 3-10.
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
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,
*
see:
E
entering spreadsheet data