The copy, cut, and paste commands for array formulas are called in the same way as for ordinary cell ranges (see the Edit content section).
When cutting out an array formula, the entire range occupied by it should be selected.
If the area allocated for insertion is larger than the area occupied by the array formula, it will be narrowed to the size of the original range.
If the area allocated for insertion is smaller than the area occupied by the array formula, it will be expanded to the size of the original range by filling in the existing cells. Note that when creating or inserting an array formula, it should not intersect:
–Cells filled with other array formulas
–Merged cells
–Pivot tables
–Smart tables if a multi-cell formula is inserted