– How to Insert a Range and Shift Cells Down
– 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 right:
Step 1: Select the data range you want to insert;

Step 2: Move the cursor to the location where you want to insert;

Step 3: Click the "Home" tab from the ribbon;

Step 4: Click "Insert" from the "Cells" section, and select "Insert Copied Cells";

Step 5: In the "Insert" dialog box, click "Shift cells right";

Step 6: Click "OK" at the bottom.
