In a spreadsheet you can copy or move information:
From one cell to another
From one range of cells to another range of cells
When you copy information, Spreadsheet creates duplicate information in the destination cells you specify and the information also remains in the original cells.
Any formulas in the copy range are propagated in the destination range. For example, a reference to the cell A1 in a formula in cell A2 will become a reference to cell B1 if the formula is copied to cell B2. You can override propagation (see Absolute addresses).
When you move information, Spreadsheet removes it from the original cells and displays it at the destination cells instead. When you move formulas, any cell references within the range are adjusted so they work in their new location. References made to cells outside the range are preserved.
In either case, if there is already information in the destination cells, Spreadsheet replaces it with the new information.
The most effective way of copying and moving information is to use drag and drop (see Drag and drop).
You can also use cut and paste in a number of ways, as explained in the following sections.
Note: As Spreadsheet is a Windows program, anything you copy or cut is placed in the Clipboard. This means that you can paste it into another spreadsheet or another type of document entirely, such as a database.
See:
Copy and moving from one cell to another
Copy and moving from one range to another