How to Delete a Range and Shift Cells Up

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".

This image has an empty alt attribute; its file name is exceldeletecell004.jpg

– An alternative way is to right-click, then select "Delete" from the list, and then select "Shift cells up" in the dialog box.

Leave a Reply