How to move cells down in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-move-cells-down-in-Excel.png)
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
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-1-How-to-move-cells-down-in-Excel.png)
– Select the cell or cells to be moved
– Right-click to display the context menu
– Select Insert
Step 2 – Choose the move option
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-2-How-to-move-cells-down-in-Excel.png)
– Select Shift cells down
– Click OK
Step 3 – View the result
![](https://spreadcheaters.com/wp-content/uploads/Option-1-Step-3-How-to-move-cells-down-in-Excel.png)
– View the result
Option 2 – Drag and drop
Step 1 – Select the cells
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-1-How-to-move-cells-down-in-Excel-1024x595.png)
- Select the cell or cells to be moved
- Position the cursor at the border of the selected area
Step 2 – Drag and drop
![](https://spreadcheaters.com/wp-content/uploads/Option-2-Step-2-How-to-move-cells-down-in-Excel-1024x556.png)
- 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
![](https://spreadcheaters.com/wp-content/uploads/Option-3-Step-1-How-to-move-cells-down-in-Excel-1024x509.png)
- Select the cell or cells to be moved
- Right-click to display the context menu
- Select Cut
Step 2 – Choose the location
![](https://spreadcheaters.com/wp-content/uploads/Option-3-Step-2-How-to-move-cells-down-in-Excel-1024x475.png)
- Position the cursor at the new location
- Right-click to display the context menu
- Select Paste