In this tutorial, you will learn how to shift cells left after deleting in Excel and Google Sheets.
Delete and Shift Remaining Cells Left
Say you have a certain data range you want to delete (in this example, B1:B4) and want to move adjacent cells from the right side to the left after deleting that range.
1. In order to do that, first (1) select the cells you want to delete, right-click and in the drop-down menu, (2) click Delete… (or use the CTRL + – shortcut).
2. After that, the Delete dialog window will appear. In it, choose Shift cells left and press the OK button.
As a result, the selected cells will be deleted, and the cells from the right side will be shifted to the left.
Delete and Shift Cells Left in Google Sheets
1. If you want to delete a certain data range (in this example B1:B4) and to shift adjacent cells from the right side of the deleted cells to the left, select the cells you want to delete and right-click.
2. In the drop-down menu, click Delete cells.
3. Then choose Shift left.
As a result, the selected cells will be deleted, and the adjacent cells will be shifted to the left.