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 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…

 

 

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

 

 

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

 

 

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…

 

 

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

 

 

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

 

 

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.

 

 

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