Copying, cutting and pasting cells
Cut, copy and paste
Select the cell or the cell area, and select
. Or, click on the Edit toolbar. Or, right-click and select . Choose the cell to which to paste the contents and select , or click on the Edit toolbar. To cut cells, click , or select .Cut or copy several cells, or cut and copy areas
You can copy separate cell areas into a target area if it contains the same number of cells as the source area. To select several source cells, hold down the <Ctrl> key and click the required cells.
Paste special
When you copy and paste the contents of multiple cells,
provides these
options:
Option | Description |
---|---|
All | The contents of the cell are inserted. |
Formulas | The formulas of the cell are inserted. |
Value | The values of the cell are inserted. |
Actions | Any actions defined in the source cell are inserted. |
Formats | The formats of the cell are inserted. |
Comments | The comments of the cell are inserted. |
Objects | The objects, for example, ListView objects or buttons, are inserted. |