See all How-To Articles

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

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

 

insert shift cells right 5

 

Insert and Shift Existing Cells Right

Say you want to insert cells and move adjacent cells to the right. There is an easy way to do that – just follow these steps:

1. First, (1) select the cells that you want to shift right, then right-click. From the drop-down menu, (2) choose Insert…

 

insert shift cells right 2

 

2. In the Insert dialog window choose Shift cells right and press the OK button.

 

insert shift cells right 3

 

As a result, a column of new cells is added, and the current data is shifted to the right.

 

insert shift cells right 4

 

Insert Multiple Columns at Once and Shift Cells Right

1. To add multiple columns at once and to shift cells right (1) select more than one column (in this example, we selected B1:C4 to add two rows at once). Then right-click the selection and from the drop-down menu, (2) choose Insert…

 

insert shift cells right 10

 

2. In the Insert dialog window click on the Shift cells right, then click OK.

 

insert shift cells right 3

 

As a result, new columns are added, and the current data is shifted right. In this example, we selected two columns and as a result, two columns are added next to them (to the left).

 

insert shift cells right 11

 

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

Insert and Shift Cells Right 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 new cells and move adjacent cells to the right, select the cells you want to shift right.

2. In the Menu, click on Insert.

3. From the drop-down menu, choose Column left.

 

insert shift cells right 7

 

As a result, new cells are added, and the current data is shifted to the right.

 

insert shift cells right 9