How to Shift Cells Down in Excel

Sometimes, when entering new data into your spreadsheet, you want to shift the old one out of the way to make space for the new one. In Excel, you can move your cells down. In this tutorial, we will explain some methods to move cells down in Microsoft Excel.

How to Shift Cells Down in Excel

You can shift Cells Down in Excel by right-clicking, clicking and dragging, via the Home tab, using Shift-Click-Drag, Right-click and drag, Inserting copied cells, or by inserting a row. Let us take a look at all these methods.

1] Shift the Excel cell by right-clicking

Select a cell in the Dataset
Right-click the cell
Select Insert from the context menu.
An Insert dialog box will open.
Select Shift cells down.
The cell is shifted down.

2] Shift the Excel cell down by clicking and dragging

Move the cursor on the edge of the cell that you want to move down until you see a double arrow.
Now, drag the cell down.

3] Shift the Excel cell down by the Home tab

Click the Home tab
Click the drop-down arrow for the Insert button
Select Insert cells.
An Insert dialog box will open.
Select Shift cells down.
The cell is shifted down.

4] Shift the Excel cell down with Shift, click and drag

Select the range of cells that you want to move.
Place the cursor on the edge of the cell
Press the Shift key, click, and drag the cells down.
A context will appear; select Move here.

5] Shift the Excel cell down with right-click and drag.

Place the cursor on the edge of the cell
Right-click and drag the cell down.
A context will appear; select Move here.

6] Shift the Excel cell down with Insert Copied Cells

Select a range of cell, right-click and select Copy.
Click the location that you want the data to go, then click the Home tab.
Click the Insert button and insert copied cell from the menu.
An Insert dialog box will open.
Select Shift cells down.

7] Shift the Excel cell down by inserting a row

Select a range of cells that you want to move.
Click the Home tab, Click the Insert button
Select insert Sheet Rows from the menu.

This will insert a new row and shift the remaining cells down.

We hope you understand how to shift cells down in Microsoft Excel.

What is the keyboard shortcut to move down a cell in Excel?

Press the shortcut keys Ctrl + Shift + =. An Insert dialog box will open. Select the Shift Cells Down option.

READ: How to view or display Document Properties in Excel

How do I drag down a cell in Excel without a mouse?

On a laptop, select a range of cells, place the cursor on the edge of the cell until you see a double arrow, then place your finger on the touchpad and drag the cell down. The cell is moved down.

READ: How to create a Heatmap in Excel.