AppleWorks 6: How to Move or Copy Spreadsheet Data

You can move data, or a copy of it, to another location. When you use the Cut or Copy command, the selected data is placed in a holding area called the Clipboard, where the text remains until you choose Cut or Copy again or you turn off your computer. The Clipboard holds the contents of only one Cut or Copy operation at a time.

When you use the Move command, you bypass the Clipboard.

Note: With cells that contain cell references, cutting or copying and then pasting cells has a different result from moving them with the Move command.

Moving or copying data via the Clipboard

To move or copy data and formulas from one location to another:
Select the cells.
Choose Cut or Copy from the Edit menu.

· Choose Cut if you want to move the selected cells.
· Choose Copy if you want to leave the selected cells in place.

Select the cell where you want to move the data. (For a range of cells, select the upper-left cell of the new location.)

Choose Paste from the Edit menu.
When you paste cells that contain relative cell references, AppleWorks updates the references.

Note: To paste the value of a cell but not the formula it contains, choose Paste Special from the Edit menu. Select Paste Values Only, then click OK.

Tip: To move selected cells quickly without using the Clipboard, drag the cells to a new location. To copy selected cells, press Option while you drag.

Moving data without using the Clipboard

To move data and formulas without using the Clipboard:
Select the cells.
Choose Move from the Calculate menu.
Type the cell address of the cell where you want to move the data. (For a range of cells, type the address of the upper-left cell of the new location.)

Tip: To quickly fill adjacent cells with the same data, or a series or pattern of data, use one of the fill commands (in the Calculate menu).

This document contains information from Help Center, the help system included with your computer.