In this tutorial, you will learn how to shift cells up after deleting in Excel and Google Sheets.
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).
2. The Delete dialog window will open and in it click on Shift cells up. When done, click the OK button.
As a result, the selected cells will be deleted and the cell from below will be shifted up.
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.
As a result, the selected cells are deleted, and the cell from below are shifted up.