Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Move Multiple Rows in Excel (3 Quick Methods)

While working in Microsoft Excel often we need to move rows or columns to different positions. Sometimes it becomes difficult to move multiple rows with data. But no worries. Today in this article, I am going to share with you how to move multiple rows in excel. Stay tuned!


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Simple Methods to Move Multiple Rows in Excel

In the following article, I have explained 3 simple and easy tricks to move multiple columns in excel.

Suppose we have a dataset of some Student Names, Departments, and Student IDs. Now utilizing some quick and easy tricks we will move multiple rows inside this data table.

Move Multiple Rows in Excel


1. Use Shift Key to Move Multiple Rows in Excel

In order to complete a task within seconds, I always prefer keyboard shortcuts. In this method, I will show you how to move multiple rows easily using the shift key from the keyboard. Follow the steps below-

Step 1:

  • Above all, select multiple contiguous rows from the dataset.
  • Now, holding the shift key place your cursor over the selected border.
  • This time you will find a 4 directional icon will appear.
  • While holding the shift key, when the icon appears, drag your selected multiple rows to any location you want.

Use Shift Key to Move Multiple Rows in Excel

  • Here I have moved the selected rows to the top.
  • Finally, we have successfully moved multiple rows using the shift

You can also perform various actions over the dataset utilizing the shift key. Like while moving multiple rows you can also copy, remove or add rows inside cells. Follow the steps.

Step 2:

  • In the same fashion, holding the shift key right click the mouse button, and drag when the 4 directional icon

Use Shift Key to Move Multiple Rows in Excel

  • After releasing the mouse button you will find various options appeared.
  • Hence, I have chosen “Shift Down and Copy” as we are moving multiple rows. You can also choose your desired option from the new window.

  • In conclusion, the contiguous multiple rows are moved from one place to another using some keyboard shortcut.

Use Shift Key to Move Multiple Rows in Excel

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


2. Utilize Cut and Insert Option to Move Multiple Rows

Well, you can also utilize the normal procedure like cutting and inserting to a new position to move multiple rows. To do so-

Steps:

  • First, choose cells and press Ctrl+X to cut.

Utilize Cut and Insert Option to Move Multiple Rows

  • Second, choose a location where you want your selected multiple rows placed.
  • While the location is selected click the right button on the mouse and choose “Insert Cut Cells”.

  • In summary, you will get your multiple rows moved to a new position.

Utilize Cut and Insert Option to Move Multiple Rows

Read More: Move Row to Bottom in Excel If Cell Contains a Value


Similar Readings


3. Use Data Sort Feature to Move Multiple Rows in Excel

This time we will use the data sort feature of excel to move multiple rows in excel. In this method, we will add a new column just by side of or dataset and rearrange it according to our choice. Follow the steps below-

Step 1:

  • Starting with, select the whole column side by side with the dataset and click the right button of the mouse.

Use Data Sort Feature to Move Multiple Rows in Excel

  • Then, in the new column, add random numbers according to your choice.

Step 2:

  • To start the sorting, choose the whole dataset and click the “Sort” option from the “Data” tab.

Use Data Sort Feature to Move Multiple Rows in Excel

  • For instance, a new window will appear named “Sort”.
  • From the new window, press the “Options” feature.

  • In the new dialog box, choose “Sort top to bottom” and hit the OK button to continue.

  • After that, the previous window will appear. From the window, choose “Column-B” from the “Sort by” option.
  • Press OK.

Use Data Sort Feature to Move Multiple Rows in Excel

  • Now, you will see the rows are rearranged according to the numbers we put in column B.

Remove number column to Move Multiple Rows in Excel

  • As we don’t need those numbers we will remove them by selecting the whole column right clicking and pressing “Delete”.

Move Multiple Rows in Excel

  • Finally, we have successfully moved multiple rows in excel. Simple isn’t it?

Move Multiple Rows in Excel

Read More: How to Move Rows to Columns in Excel (4 Effective Ways)


Things to Remember

  • You can move only the contiguous rows or columns by applying methods 1 and 2. To move non-contiguous rows perform method 3.

Conclusion

In this article, I have tried to cover all the methods to move multiple rows in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo