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

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on December 9, 2022

This tutorial demonstrates 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, select the cells you want to shift right, then right-click. From the drop-down menu, choose Insert…

 

insert shift cells right 2

 

  1. In the Insert dialog window choose Shift cells right and click OK.

 

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 select more than one column (here, select B1:C4 to add two rows at once). Then right-click the selection and from the drop-down menu, choose Insert…

 

insert shift cells right 10

 

  1. In the Insert dialog window click on the Shift cells right, and 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, two columns were selected 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, 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

AI Formula Generator

Try for Free

See all How-To Articles