Insert copied cells similar to Excel


Version: 2025b

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-31032


Insert the copied data and push original data downwards

System variable: @WPI to copy how to paste insert if cells copied is more than the number of cell selection in destination

  • 0 (default) – No replacing. Insert all copied cell and push selection downwards. E.g. Copy A1 to A4 (4 cells). Select B2, B3 (2 cells) to paste (insert). A1-A4 will be pasted to where B2-B5 is. Original selection B2, B3 and all data below will be pushed to B6, B7 and on.

    image-20250505-165206.png

  • 1 – Selection will be replaced. E.g. Copy A1 to A4 (4 cells). Select B2, B3 (2 cells) to paste (insert). A1-A4 will be pasted to where B2-B5 is. Original selection B2-B3 will be gone. Original B4, B5 and all data below will be pushed to B6, B7 and on.

    image-20250505-165414.png