How to shift rows in Excel down (5 Easy Ways)

Some Excel worksheets have numerous rows such that working and sifting through them can be stressful. You may need to reorder your rows and columns now and then to make work easier for you. Therefore, any Excel user needs to learn how to move rows and columns.In our guide below, we explain the different methods you can use to shift rows in Excel. Here we go.

How to shift rows by inserting a new row in Excel

1. Open your spreadsheet

2. Click on the cell in the row that you wish to move down.

3. Open  Home

4.  Click on the Insert option under the cells group

5. Select Insert Sheet Rows.

Click insert then select insert sheet rows.

Afterward, you will notice a row has been included and the existing ones have shifted down.

The rows shift down in Excel

6. Repeat the steps above as needed.

Using the Context menu

1. In an open Excel worksheet, select the row you wish to move down.

2. Cut the selected row using the keyboard keys Ctrl + X.

3. Now choose where you wish to inject a row and right click

4. Choose the option Insert Cut Cells.

Select insert cut cells to shift rows down in Excel

Shift rows in Excel Down by cutting and pasting

You can shift an entire row down in Excel by cutting and pasting it to the preferred location. It works when it comes to shifting rows up. The best thing about this method is that you can use it to shift multiple rows down.

1. Click the numbers on the left to select the rows you wish to shift down (Hold ctrl to select multiple rows)

Hold ctrl button to select multiple rows in Excel

2. Right click and press cut or use the shortcut ctrl + X

cut the selected rows

3. Move down to your preferred row and paste the rows

paste the rows

Download the practice workbook

Shift rows down template

Using the Sort feature to shift rows down

1. To do this, right-click on the column label and select Insert from the context menu.

2. Label your rows

Number the rows in the order you would wish to rearrange them

3. Highlight all the data

Select the whole data

4. On the main menu ribbon, navigate to sort and filter

5. In the drop-down menu, select Custom Sort to launch a dialog box.

Select custom sort to rearrange the rows

6. Select Sort as illustrated by the image below

7. Next, select the option Smallest to Largest in the Order field.

Choose sort from the smallest to the largest

8. Apply changes. You will notice some of your rows will have shifted up and others down.

Some rows will shift down while others will shift up

9. Get rid of the helper column that you created

Delete the extra column

Using drag and drop method

It is the easiest and fastest way to use it when you want to move rows in Excel. You can either shift the rows by dragging and replacing, dragging and copying or dragging and moving. Here we discuss how to do all this.

Similar Article: How to move cells in Excel to the right (Easy Guide)

Dragging and Replacing Rows

1. Select the row or rows you want to move. You can select an entire row by clicking the specific row number, or you can click on any cell within the row and press the keys Shift + Spacebar.

Select the row you wish to shift down

2. Move the mouse to the bottom border like illustrated below.

Move the cursor to the border

3. Hold down the left mouse, click and drag it into the desired location.

4. Release your mouse. You will get a pop-up caution asking “There’s already data here. Do you want to replace it?” if you wish to move data to an empty row, Excel will not ask you this.

5. Click the OK button to replace the data.

How to shift multiple rows down

Sometimes you may want to shift rows down. The best way around this is to copy and paste. Select the rows you wish to shift down, then copy and paste them.

Similar articles:

How to insert multiple rows in Excel above

How to delete everything below row in Excel: 5 easy ways

Leave a Reply

Discover more from Excel Wizard

Subscribe now to keep reading and get access to the full archive.

Continue reading