How to move cells down in Excel

You can watch a video tutorial here.

Spreadsheets in Excel are organized as columns and rows. Each intersection of the row and column is called a cell. When typing values in Excel, you may need to move the cells down. For example, you may need to insert a new column header into a table.

Option 1 – Insert a row

Step 1 – Select the row

– Select the cell or cells to be moved
– Right-click to display the context menu
– Select Insert

Step 2 – Choose the move option

– Select Shift cells down
– Click OK

Step 3 – View the result

– View the result

Option 2 – Drag and drop

Step 1 – Select the cells

• Select the cell or cells to be moved
• Position the cursor at the border of the selected area

Step 2 – Drag and drop

• When the cursor changes to a move pointer, click the left mouse button
• Holding down the button, drag the area down
• Release the mouse button when the cells are in the new location

Option 3 – Cut & paste

Step 1 – Select the cells

• Select the cell or cells to be moved

• Right-click to display the context menu
• Select Cut

Step 2 – Choose the location

• Position the cursor at the new location 
• Right-click to display the context menu
• Select Paste