Inserting copied cells

<< Click to Display Table of Contents >>

Inserting copied cells

It happens from time to time that you want to place copied cells at a position where values already exist. If you do not want to overwrite these values, but move them when pasting something from the clipboard, the following option is available.

The ribbon command Home | group Cells | Insert insert_cells_icon | Insert copied cells inserts cells, rows or columns from the clipboard into the worksheet.

insert_cells_dialog

The program opens a dialog box where you can choose in which way the cells should be inserted:

Move cells down

The copied cells from the clipboard are inserted at the selected position.
The cells below the insertion are moved down.

Move cells to the right

The copied cells from the clipboard are inserted at the selected position.
The cells to the right of the insertion are moved further to the right.

Insert complete rows

The copied rows from the clipboard are inserted at the selected position.
The rows below the insertion are moved down.        

Insert complete columns

The copied columns from the clipboard are inserted at the selected position.
The columns to the right of the insertion are moved further to the right.