How to Move a Row in Excel (8 Quick Tricks)

In truth, working with large sets of data in Excel and keeping everything organized is hard. Sometimes you may want to move a particular row to another area of your worksheet to make your work more systematized and effective. As with anything in Excel, there are multiple ways of doing this, therefore, in this article, we’ll discuss 8 quick and easy methods on how to move a row in Excel. In addition, we’ll also learn to move multiple rows in Excel.


Download Practice Workbook


8 Tricks to Move a Row in Excel

At the very beginning, let’s consider the ICC Men’s Ranking dataset in the B4:L7 cells containing the “Ranking”, “ODI”, “Test”, and “T20” rows respectively. Here, we want to move the rows using various built-in features of Excel, henceforth, let’s describe each method with the necessary illustrations.

Dataset for how to move a row in excel

Here, we have used the Microsoft Excel 365 version; you may use any other version according to your convenience.


1. Using Drag and Drop Method

First of all, let’s start with a simple yet effective way that involves dragging and dropping to move a row in Excel.

📌 Steps:

  • In the first place, click the row number, in this case, Row 5 to select the entire row >> hover the cursor at the border until the Four-headed arrow appears.

Using Drag and Drop Method

  • Next, hold down the SHIFT key >> Left-click on the mouse >> drag the cursor to move the “ODI” row below.

Holding SHIFT Key to drag rows

Now, you can observe the steps in real time in the GIF below.

how to move a row in excel using Drag and Drop Method


2. Utilizing Cut & Paste Method

Again, we can utilize the classical Cut & Paste method to move a row in Excel. It’s simple and easy, so just follow along.

📌 Steps:

  • First, select the B5:L5 cells >> Right-click to open the menu >> select the Cut option.

Utilizing Cut & Paste Method

  • Second, move to the B8 cell >> Right-click and choose Paste option.

Pasting data

  • Additionally, select the now empty B5:L5 range >> hit CTRL + – (Minus) keys >> check the Shift cells up radio button>> press OK to remove the empty cell.

Deleting empty row and shift cells up

Finally, the results should look like the image given below.

how to move a row in excel using Cut & Paste Method


3. Applying Cut & Replace Method

Besides, we can apply a keyboard shortcut to cut and replace a row if needed. Hence, let’s see it in action.

📌 Steps:

  • Initially, select Row 5 >> move the cursor to the edge such that the Four-sided arrow appears >> drag the selection to move the row.

Applying Cut & Replace Method

  • Afterward, a warning pops out >> hit the OK button.

Lastly, the final output should appear in the picture below.

Results for cut and paste

Moreover, we can follow the steps in the animated GIF below.

how to move a row in excel using cut and paste method


4. Employing Copy & Replace Method

Alternatively, we can perform copy and replace to move a row in Excel by following the process described below.

📌 Steps:

  • To begin with, select Row 5 >> move the cursor to the sides so that the Four-headed arrow can be seen >> hold down the CTRL key and drag the cursor.

Employing Copy & Replace Method

Boom! That is how simple it is to move a row in Excel.

Results for Copy & Replace Method

At this point, the GIF below recaps the described steps.

how to move a row in excel with copy and replace method


5. Using Data Sort Feature

Conversely, we can also utilize the Data Sort feature to insert a new row and then move the existing rows below.

📌 Steps:

  • To start with, highlight the B5:L5 range >> Right-click and jump to the Insert option.

Using Data Sort Feature

  • Now, this inserts a new empty row >> populate this empty row with data as shown in the screenshot below.

how to move a row in excel with sort data feature


Similar Readings:


6. Moving a Row to Another Worksheet

Further, Excel enables us to move a row into another worksheet very easily; just follow the steps shown below.

📌 Steps:

  • At the very start, choose the B5:L5 array >> use the CTRL + C shortcut to copy the data >> proceed to another worksheet, here it is the “New Sheet”.

Moving a Row to Another Worksheet

  • Later, hit the CTRL + V keys to paste the data into any cell of your choice.

how to move a row in excel moving a row to another worksheet


7. Shifting Multiple Consecutive Rows Without Replacing

For one thing, we can extend the previous method to copy multiple rows of data from the source worksheet to a new worksheet. In fact, the process is remarkably similar, so let’s go through the steps.

📌 Steps:

  • First and foremost, hold down the SHIFT key >> click on Rows 5 and 7 to select the consecutive rows >> click CTRL + C to copy the information.

Shifting Multiple Consecutive Rows Without Replacing

  • From this point, jump to the “New Sheet” >> use CTRL + V to paste.

Using keyboard shortcut to paste

In addition to this, see the steps in the GIF for a live demonstration.

how to move a row in excel Shifting Multiple Consecutive Rows Without Replacing


8. Moving Multiple Non-Consecutive Rows

Now, what if we want to move multiple non-consecutive rows from a source worksheet to a destination worksheet? Then, our next method has you covered, therefore let’s glance at the procedure in the following steps.

📌 Steps:

  • In the first place, hold down the CTRL key >> select as many rows as you like, for instance, we’ve chosen Rows 5 and 7 >> copy the text into the clipboard.

Moving Multiple Non-Consecutive Rows

  • Following this, navigate to the “New Sheet” >> paste the data as shown in the figure below.

Apart from this, the animated GIF below also shows the above steps.

how to move a row in excel Moving Multiple Non-Consecutive Rows


How to Move Multiple Rows in Excel

Last but not least, we can move multiple rows in Excel by using a handy keyboard shortcut, hence, let us begin.

📌 Steps:

  • At this time, select the B6:L7 range of cells >> hit the CTRL + X keys to cut the data.

How to Move Multiple Rows in Excel

  • In turn, jump to the B5 cell >> apply CTRL + V keys to paste the data into the B5:L6 cells.

Furthermore, the GIF allows you to follow the steps in real time.

GIF for How to Move Multiple Rows in Excel


Practice Section

We have provided a Practice section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

Practice Section


Conclusion

In essence, this article shows 8 effective ways of how to move a row in Excel. So, read the full article carefully and download the free workbook to practice. Now, we hope you find this article helpful, and if you have any further queries or recommendations, please feel free to comment here. Lastly, visit ExcelDemy for many more articles like this.


Further Readings

Sanjida Ahmed

Sanjida Ahmed

Hello World! This is Sanjida, an Engineer who is passionate about researching real-world problems and inventing solutions that haven’t been discovered yet. Here, I try to deliver the results with explanations of Excel-related problems, where most of my interpretations will be provided to you in the form of Visual Basic for Applications (VBA) programming language. Being a programmer and a constant solution seeker, made me interested in assisting the world with top-notch innovations and evaluations of data analysis.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo