7.12.10.  Copy

Copy creates a copy of the current selection (rows or cells). This copy can be copied by inserting [Insert] or overwrite [Overwrite] at any other position.

[Note]Note

Paste [Insert] inserts above the selection.

If overwritten [Overwrite], it is inserted at the marker.

Example: Copying cells

  1. Mark the cells to be copied.

  2. Click the Copy button.

    -> The copy is temporarily stored in the temporary memory.

  3. Select the cell above which the copy is to be inserted into the table.

  4. Click on the Insert button.

    -> The marked cells are inserted before the marked cell.

    [Note]Note

    When inserting certain cells - not complete rows - a new row or several new rows are created with only the selected content of the original table.

Automated filling of table cells

Instead of filling data manually, cells can be filled according to a certain pattern.

Procedure:

  1. Mark the cells to be copied with the help of shift key.

  2. Pull down the marked block with a click on the drag point (small black rectangle).

Examples:

  • A sequence of the numbers "1,2,3,4,5" is logically continued.

  • A sequence of the numbers "1,2,4,5" is copied in blocks.

  • There are cases where both a logical continuation of a sequence of numbers and a copying as block may make sense. With pressed Ctrl key the marked block is copied, without Ctrl key the sequence of number is logically continued.

    Without holding down the Ctrl key:

    -> The sequence is continued by adding 90 in each step.

    With the Ctrl key held down:

    -> The sequence is continued by copying the marked block:

[Note]Note

The examples above use numbers of the data type [Data type] "integer [Integer] ". When using decimal numbers [Decimal number], the behavior described is identical. Text is always copied in blocks.