How to Rearrange Rows in Excel (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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


How to Rearrange Rows in Excel: 4 Ways

In this article, we will see the use of the Cut and Insert method, the copy method, and the use of the 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 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 Move Rows Down in Excel


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


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+X.

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

  • As a result,  rows above will be arranged automatically by shifting down.

Cut and Insert Method to Rearrange Rows

Read More: How to Move Rows Up in Excel


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 the 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


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.


Download Practice Workbook


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


<< Go Back to Move Rows | Rows in Excel | Learn Excel

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.
Mahbubur Rahman
Mahbubur Rahman

MAHBUBUR RAHMAN is a leather engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SPSS, STATA, Deep Neural Networks, and Machine Learning. Holding a B.Sc in Leather Engineering from Khulna University of Engineering & Technology, he's shifted to become a content developer. In this role, he crafts technical content centred around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo