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.
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.
- Select the rows first and press CTRL+C to copy the rows.
- Now, select cell B6 and right-click the mouse button, and click Insert Copied Cells.
- 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.
- That’s it, we rearranged the rows.
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.
- Select the rows we want to move.
- Now, position the mouse at the position top of the selected borderline so that a moving arrow sign of four directions appears.
- 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.
- [Fixed!] Unable to Move Cells in Excel (5 Solutions)
- Move and Size with Cells in Excel (3 Examples)
- How to Move Highlighted Cells in Excel (5 Ways)
- Move One Cell to Right Using VBA in Excel (3 Examples)
- How to Use the Arrows to Move Screen Not Cell in Excel (4 Methods)
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.
- First, we will select the rows we want and press CTRL+C.
- After that, go to cell B5 and click the right button on the mouse and click Insert Cut Cells.
Method 4: Rearrange Rows by Sorting
We can also rearrange rows by Sorting. Let’s, sort the data alphabetically.
- 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.
- Now, a dialogue box will pop up and select Expand current selection and click Sort.
- Finally, rows will be rearranged as follows.
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.
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.