– How to Insert a Range and Shift Cells Right
– How to Delete a Range and Shift Cells Left
– How to Delete a Range and Shift Cells Up
Please follow the steps below to insert a data range and shift other cells down:
Step 1: Copy the data range you want to insert;
Step 2: Click the cell where you want to insert;
Step 3: Click the "Home" tab from the ribbon;
Step 4: Click "Insert" in the "Cells" section, and select "Insert Copied Cells";
Step 5: In the "Insert" dialog box, click "Shift cells down";
Step 6: Click "OK" at the bottom.