See all How-To Articles

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

This tutorial demonstrates 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, select the cells you want to delete, then right-click. In the drop-down menu, choose Delete… (or use the CTRL + – shortcut).

 

delete shift cells up 2

 

  1. The Delete dialog window opens. Click on Shift cells up, and then OK.

 

delete shift cells up 3

 

As a result, the selected cells are deleted and the cell from below is 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 (here, 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

See all How-To Articles