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

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


Download Practice Workbook

Download the following workbook to practice by yourself.


4 Simple Methods to Move Rows in Excel

1. Applying Excel Cut Command to Move Rows

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. Move 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 Excel

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

3.1 Moving Rows by Replacing

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 Moving 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. 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)


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

Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo