Cut Range

The Cut Range function cuts the Source range and pastes it to the Placement Cell using the Type operation such as Direct, Offset, Append, and Insert. All formats, formulas and values from the Source are pasted to the Placement.

Note, charts within the Source range are not cut and pasted with this function.

Settings

Delete Range

If set to Yes, then the Source range is deleted after it is cut and pasted rather than just cleared from the worksheet.

Shift Cells

If Delete Range is set to Yes, this determines how the cells are shifted after the range is deleted, either Up or Left. Otherwise, this setting has no effect.

Example

To cut a number of rows of data starting at $A$2:$D$2, paste them to the next empty cell at or beneath $F$4.

Source $A$2:$D$2, Down, All cells are empty

Placement $F$2, Append, Down

Setting

Delete Range No

Shift Cells Up