How to Rearrange Rows in Excel (4 Ways)

Sometimes, while working in Microsoft Excel we may feel the need to rearrange rows according to our convenience. Suppose, we have a dataset like the image below and we want to move the rows marked green to above or below. In this article, we will learn how to rearrange rows in Excel using 4 simple methods.

how to rearrange rows in excel


Download Practice Workbook


4 Ways to Rearrange Rows in Excel

In this article, we will see the use of the Cut and Insert method, the copy method, and use of shift key and mouse button to rearrange rows in Excel.


Method 1: Rearrange Rows Using Copy Method

It is the first thought that comes into everyone’s mind. Although it is a time-consuming method, we will have a look at this method just for your better understanding. Here, we will rearrange the rows from 8 and 9 positions to just below row 5.

Steps:

how to rearrange rows in excel

  • Now, select cell B6 and right-click the mouse button, and click Insert Copied Cells.

how to rearrange rows in excel by copy

  • As a result, a dialogue box will pop up, and select OK, the rows will be copied. For rows, Shift cells down will be selected automatically, keep that as it is.

  • Finally, select the rows selected previously and right click on the mouse button, and delete the rows.

how to rearrange rows in excel using copy and delete

  • That’s it, we rearranged the rows.

Read More: How to Shift Data Up in Excel (3 Easiest Ways)


Method 2: Rearrange Rows by Mouse Button

We can easily move rows by the press and hold method using the mouse. Here, we will rearrange the 8 and 9 rows by shifting them from their position to 6 and 7.

Steps:

  • Select the rows we want to move.

how to rearrange rows in excel by drag and move

  • Now, position the mouse at the position top of the selected borderline so that a moving arrow sign of four directions appears.

how to rearrange rows in excel by drag and move

  • Then, press and hold the SHIFT key on the keyboard and drag it to the position just below row 5 where a green borderline appears like the image below.

  • Finally, release the SHIFT key and Mouse button and, the result will be as in the image below.

how to rearrange rows in excel by drag and move

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


Similar Readings


Method 3: Cut and Insert Method to Rearrange Rows

We want to move our two desired rows just below the header. We want these rows to be in rows numbers 5 and 6. Let’s see, how to do it with the cut and insert method.

Steps:

  • First, we will select the rows we want and press CTRL+C.

how to rearrange rows in excel by cut and insert

  • After that, go to cell B5 and click the right button on the mouse and click Insert Cut Cells.

how to rearrange rows in excel by cut and insert

how to rearrange rows in excel by cut and insert

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


Method 4: Rearrange Rows by Sorting

We can also rearrange rows by Sorting. Let’s, sort the data alphabetically.

Steps:

  • First, select the columns we want to sort and go to the Data tab and click A to Z option as shown in the image.

how to rearrange rows in excel by sorting

  • Now, a dialogue box will pop up and select Expand current selection and click Sort.

  • Finally, rows will be rearranged as follows.

how to rearrange rows in excel by sort option

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


Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.


Conclusion

That’s all for the article. These are 4 different methods for how to rearrange rows in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.


Related Articles

Mahbub
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo