Wasim Akram
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.
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.
- 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
- 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.
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.
- 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.
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.
- 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.
- 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.
- Now, you will see the rows are rearranged according to the numbers we put in column B.
- As we don’t need those numbers we will remove them by selecting the whole column right clicking and pressing “Delete”.
- Finally, we have successfully moved multiple rows in excel. Simple isn’t it?
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.
