– How to Insert a Range and Shift Cells Right
– How to Insert a Range and Shift Cells Down
– How to Delete a Range and Shift Cells Left
Please follow the steps below to delete cells and shift other cells up:
Step 1: Select the data range that you want to delete;
Step 2: Click "Home" tab from the ribbon;
Step 3: Click "Delete" in the "Cells" section and click "Delete Sheet Rows" from the drop-down list;
Step 4: In the "Delete" dialog box, click "Shift cells up".
– An alternative way is to right-click, then select "Delete" from the list, and then select "Shift cells up" in the dialog box.