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

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on December 9, 2022

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

AI Formula Generator

Try for Free

See all How-To Articles