See all How-To Articles

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

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

 

delete shift cells left 2

 

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).

 

delete shift cells left 3

 

2. After that, the Delete dialog window will appear. In it, choose Shift cells left and press the OK button.

 

delete shift cells left 4

 

As a result, the selected cells will be deleted, and the cells from the right side will be shifted to the left.

 

delete shift cells left 5

 

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

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.

 

delete shift cells left 7

 

As a result, the selected cells will be deleted, and the adjacent cells will be shifted to the left.

 

delete shift cells left 9