See all How-To Articles

How to Insert and Shift Cells Down in Excel & Google Sheets

In this tutorial, you will learn how to shift cells down when inserting in Excel and Google Sheets.

 

insert shift cells down 5

 

Insert and Shift Existing Cells Down

There is an easy way to shift row(s) of cells downward. Just add a row above them.

1. First, (1) select the cells in the highest row that you want to shift downward (in this example, A2:C2), then right-click and from the drop-down menu, (2) choose Insert…

 

insert shift cells down 2

 

2. The Insert dialog window will open. In it choose Shift cells down, then press the OK button.

 

insert shift cells down 3

 

As a result, a new row is added, and the current data is pushed down.

 

insert shift cells down 4

 

Add Multiple Rows at Once and Shift Cells Down

1. To add multiple rows at once and shift cells downward, (1) select multiple rows (for this example, we use A2:C4 to add three rows at once). Then right-click the selection and from the drop-down menu, (2) choose Insert…

 

insert shift cells down 10

 

2. In the Insert dialog window, choose Shift cells down, then click the OK button.

 

insert shift cells down 3

 

As a result, the new rows are added, and the other cells are pushed down. In this example, we selected three rows and as a result, three rows were added above them.

 

insert shift cells down 11

 

Note: When you insert an entire row, Excel automatically shifts cells down. For an entire column, it shifts cells right.

Insert and Shift Cells Down in Google Sheets

In Google Sheets, you start by choosing where you want the new cells to be, rather than where the old cells should go.

1. To insert a new row and shift the row(s) of cells downward in Google Sheets, select the cells in the highest row you want to shift downward.

2. Then in the Menu, click Insert.

3. From the drop-down menu, choose Row above.

 

insert shift cells down 7

 

As a result, a new row is added, and the other cells are shifted down.

 

insert shift cells down 9