See all How-To Articles

How to Delete and Shift Cells Up in Excel & Google Sheets

In this tutorial, you will learn how to shift cells up after deleting in Excel and Google Sheets.

 

delete shift cells up 1

 

Delete and Shift Remaining Cells Up

Say you want to delete a certain data range (in this example A3:C3) and move adjacent cells up after that.

1. First, (1) select the cells you want to delete, then right-click. In the drop-down menu, (2) choose Delete… (or use the CTRL + – shortcut).

 

delete shift cells up 2

 

2. The Delete dialog window will open and in it click on Shift cells up. When done, click the OK button.

 

delete shift cells up 3

 

As a result, the selected cells will be deleted and the cell from below will be shifted up.

 

delete shift cells up 6

 

Note: When you delete an entire row, Excel automatically shifts cells up. For an entire column, it shifts cells left.

Delete and Shift Cells Up in Google Sheets

To delete a certain range (in this example, A3:C3) and to move the adjacent cells from below up, follow these steps:

1. First, select the cells you want to delete, then right-click.

2. From the drop-down menu choose Delete cells,

3. Then click on Shift up.

 

delete shift cells up 5

 

As a result, the selected cells are deleted, and the cell from below are shifted up.

 

delete shift cells up 7