How to Move Rows in Excel (4 Simple & Quick Methods)

Get FREE Advanced Excel Exercises with Solutions!

A lot of times, we have to move the rows in Excel datasheets to meet certain requirements. This article will show you the simple methods to Move Rows in Excel.

To help you understand better, I’m going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company.

move rows excel

1. Applying Cut Command to Move Rows in Excel

The Excel Cut command is a very useful tool and it can be used for Moving Rows. The chosen row to cut can be placed in a blank row or another pre-occupied row but it will simply replace the row.

STEPS:

  • First of all, select row 5.

Applying Excel Cut Command to Move Rows

  • Next, select the Scissor-shaped icon under the Home tab.

Applying Excel Cut Command to Move Rows

  • Then, select row 11 for this example, or any other row where you want to insert the cut row.

Applying Excel Cut Command to Move Rows

  • Now, select the Paste under the Home tab.

  • Finally, you’ll get to see the 5th row being inserted into the 11th row.

Read More: How to Shift Cells Right in Excel (4 Quick Ways)


2. Moving Rows with Excel Copy Command

We can also use the Excel Copy command to Move Rows.

STEPS:

  • In the beginning, select row 5.

Move Rows with Excel Copy Command

  • Next, select the Copy under the Home tab.

Move Rows with Excel Copy Command

  • Then, select row 11 or any other row where you want to insert the copied row.

Move Rows with Excel Copy Command

  • Now, select Paste under the Home tab.

  • At last, you’ll see a copy of the 5th row in the 11th row.

Read More: How to Move Rows Up in Excel (2 Quick Methods)


Similar Readings


3. Using Mouse to Move Rows

In this method, we’ll simply use the Mouse to move rows in Excel datasheets.

3.1 Move Rows by Replacing Existing Data

Here, we’ll move rows by dragging the mouse and it will replace the pre-occupied contents in our destination.

STEPS:

  • First of all, select a row or multiple rows you want to move.
  • For this example, select rows 5 and 6.

Using Mouse to Move Rows in Excel

  • Next, hover the mouse over the edge of selected rows and the cursor will get changed to an Arrow icon.
  • Now, click and drag the rows and place them over rows 9 and 10.
  • Then, release the click, and in doing so, a dialogue box will pop out.
  • There, press OK.

  • In the end, the 9th and 10th rows will be replaced by the 5th and 6th rows.

Read More: How to Shift Rows Down in Excel (3 Simple & Easy Ways)


3.2 Move Rows without Losing Data

We can also use the Mouse to move rows but this time, without losing any data from our Excel sheets.

STEPS:

  • Firstly, select rows 5 and 6.

Using Mouse to Move Rows in Excel

  • Next, hover the mouse over the edge of selected rows. The cursor will change to an Arrow icon.
  • Now, click and drag the rows and place them over rows 9 and 10.
  • This time, press the ‘Shift’ key before releasing the click.
  • Finally, the 5th and 6th rows will be placed at the 9th and 10th row respectively and other rows will get rearranged among themselves.

Read More: How to Move Cells without Replacing in Excel (3 Methods)


4. Applying Excel Sort Feature to Reorder Rows

We’ll use the Excel Sort feature in our last method to move rows according to our requirements.

Excel Sort Feature to Reorder Rows

STEPS:

  • In the beginning, select the left-most column.
  • In this example, select the entire column A.

Excel Sort Feature to Reorder Rows

  • Next, Right-Click on the mouse and select Insert from the list.

Excel Sort Feature to Reorder Rows

  • Here, it’ll simply add a blank column.

Excel Sort Feature to Reorder Rows

  • Now, place the Serial Numbers according to your requirement like below.

Excel Sort Feature to Reorder Rows

  • Then, select the entire range of cells to work with.

Excel Sort Feature to Reorder Rows

  • After that, select Sort Smallest to Largest from Sort & Filter drop-down list in the Editing group under the Home tab.

Excel Sort Feature to Reorder Rows

  • Selecting the feature, you’ll see that the rows have rearranged among themselves according to the serial number from smallest to largest.

  • Now, select the entire column A again and Right-Click on the mouse.
  • There, select Delete from the list.

  • Finally, you’ll get to see your desired outcome.

Read More: How to Shift Cells Up in Excel (5 Quick Ways)


Download Practice Workbook

Download the following workbook to practice by yourself.


Conclusion

Now you will be able to Move Rows in Excel using the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo