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. |