How to Insert Cells and Shift Cells Right

– How to Delete Cells and Shift Cells Up
– How to Insert Cells and Shift Cells Down
– How to Delete Cells and Shift Cells Left

When working with Excel, you may often need to insert cells. Please follow the steps below to insert cells and shift other cells right:

Step 1: Click the cell or cells where you want to insert;

This image has an empty alt attribute; its file name is excelinsert001.jpg

Step 2: Right-click and select "Insert" from the dialog box.

Alternatively, please use the commands in the ribbon.

Step 1: Click the "Home" tab from the ribbon;

This image has an empty alt attribute; its file name is excelhometab001.jpg

Step 2: Click "Insert", and select "Insert Cells" from the drop-down list;

This image has an empty alt attribute; its file name is excelinsert002.jpg

Step 3: In the "Insert" dialog box, click "Shift cells right";

Step 4: Click "OK" at the bottom.

Leave a Reply