How to Move a Row in Excel (6 Methods)

Working with a big amount of data in Excel and keeping everything organized is hard. Sometimes you may want to move a particular row to another area of your worksheet to make your work more systematized and effective. In Excel, you can do that in some easy ways. This article will show you 6 easy methods on how to move single and multiple rows in Excel in detail with pictures.

Download Practice Workbook

You can download the practice workbook from here,

6 Easy Methods to Move Rows in Excel

Below are 6 of the most effective and easiest methods to move rows in Excel,

1. Drag and Drop Method

The drag and drop method in Excel is the most familiar method around the world due to its simplicity. Especially in moving rows and columns around the worksheet, nothing can beat this method.
The steps on how to move a single row in Excel by dragging and dropping is described below,

  1. Select the row that you want to move by simply clicking on the row number on the left side of the sheet.drag and drop method to move a row in excel
  2. Place the cursor of your mouse over the border of the selected row. You will see a four-directional arrow sign. Select the row by left click on your mouse and drag the row where you want to place it.dragging & dropping row
  3.  It will move the row onto the new place that you selected in the sheet.dropping row

2. Cut and Paste Method

The steps on the cut and paste method in Excel is described below,

  1. Select the row that you want to move by simply clicking on the row number on the left side of the sheet.
  2. Right-click on the row; from the appeared option list, select Cut.cut & paste to move a row
  3. It will draw a dashed rectangular box over the row.pasting row to move
  4. Now select the new row number where you want to show the result and right-click on the row. From appeared option list, select Paste.cut and paste row formula

    v. It will move the row onto the new place that you selected in the sheet.

pasting new updated row

3. Using the Data Sort Feature

Working with a large amount of data it is obvious that sometimes you could forget to write certain values in a certain row in the sheet. Using Data Sort Feature in Excel can solve this problem as well.

  1. Select the row number above where you want to display the values.
  2. Right-click on the row; from the appeared option list, select Insert.inserting new row
  3. A completely new row will appear above the previously selected row.newly added row by insert command

    iv. Now in the new row, simply write whatever you needed.

new row by data sort method

4. Move a Row to Another Sheet

What if, suddenly you need to transfer a whole row from one sheet to another? This is also possible in a very easy way in Excel.

  1. Select the row that you want to move by simply clicking on the row number on the left side of the sheet.
  2. Right-click on the row; from the appeared option list, select Cut or Copy according to your need (if you want to keep a copy of the row in the previous sheet then select Copy, and if you don’t want to completely transfer the row in the new sheet then select Cut).copy row to move row to another sheet
  3. It will draw a dashed rectangular box over the row.move row another sheet by copying
  4. Now hover over to the bottom of your worksheet, select the sheet that you want your row in.
    move row another sheet
  5. Now select the new row in the new sheet by simply clicking on the row number on the left side of the sheet.
  6. Right-click on the row. From appeared option list, select Paste.move row another sheet by pasting

    vii. It will move the row onto the new place in the new sheet.

move row another sheet result

5. Method to Move Multiple Consecutive Rows

Till now all we have done is work on moving a single row. But what will happen when you need to move multiple rows? Let’s find out what Excel can offer in that regard!

  1. In the beginning, select the first row that you want to move by simply clicking on the row number on the left side of the sheet.multiple consecutive rows move
  2. Next, hover over your mouse to the last row in the dataset.selecting last row of dataset
  3. Select the last row number while pressing the Shift key on your keyboard. It will select all the data between your first and last selected rows.multiple consecutive rows move
  4. Place the cursor of your mouse on the selected dataset. Right-click on the mouse, from the appeared option list, select Cut or Copy according to your need (if you want to keep a copy of the rows in the previous sheet then select Copy, and if you don’t want to completely transfer the rows in the new sheet then select Cut).multiple consecutive row move by copy paste
  5. It will draw a dashed rectangular box all over the rows.multiple consecutive row selecting
  6.  Now select the new row number where you want to place the multiple rows.selecting new row to place dataset
  7. Right-click on the mouse, from the appeared option list, select Paste.pasting multiple consecutive rows
  8. It will move the rows onto the new place that you selected in the sheet.pasting multiple consecutive rows
  9. This process also can be done by the Drag and Drop method that we discussed above.
    First, select the first and last row number while pressing the Shift key on your keyboard that you know already. Now place the cursor of your mouse over the border of the selected rows. You will see a four-directional arrow sign. Select the set rows by left click on your mouse and dragging the set where you want to place it.selecting consecutive rows placing

    x. It will also move the rows onto the new place that you selected in the sheet.

new updated consecutive rows

6. Method to Move Multiple Non-Consecutive Rows

Now you know how to move multiple rows that are right next to each other in an Excel sheet. But what happened in case of the rows are not to each other? Excel has an excellent solution to this problem as well.

  1. Select the first row that you want to move by simply clicking on the row number on the left side of the sheet.multiple non consecutive rows move
  2. Now select another row from anywhere on the sheet that you need by clicking on the row number while keep pressing the Ctrl key on your keyboard. It will only select the rows that you want to move.selecting multiple non consecutive row
  3. Now right-click on the mouse (must remember to hold the Ctrl key pressing while right-clicking). From the appeared option list, select Copy.copying multiple non consecutive rows
  4. It will draw a dashed rectangular box to only the selected rows.copying and selecting multiple non consecutive rows
  5. Now select the new row number where you want to place the multiple copied rows. Right-click on the mouse, from the appeared option list, select Paste.pasting multiple non consecutive rows
  6. It will move the rows onto the new place that you selected in the sheet.

    Conclusion

    Moving rows in Excel is one of the most common procedures that we need to do in our daily life to keep our data organized. This article was made to help you keep your stuff coordinated. Hope this article has been very beneficial to you.

Sanjida Ahmed

Hello, this is Sanjida, an Engineer who loves Sports a lot. Here I try to solve Excel problems with you. Hope I could be a great help to you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo