While working in Excel we might need to re-arrange data between rows and cells. Sometimes there is a possibility when you need to swap your data cells or range between rows and columns. Today we will learn three methods to swap data between rows.
Download Practice Workbook
Download this practice sheet to practice while you are reading this article.
Two Methods to Swap Rows in Excel
1. Creating a new row and swap
2. Using Mouse and Shift Key
Also, we will discuss an Extra method for swapping rows and cells.
1. Creating A New Row And Copy-Paste
Suppose, we have a range of data like the one given below in the picture.
To swap rows in Excel let’s follow these steps.
- Let’s say we want to swap the entire row named “Tywin” and place him under “Emily”. For that, select the row number of “Tywin” by right-clicking the mouse and click “Insert”.
- A new row is created under “Emily”. Now copy the data of “Tywin” by holding and dragging the mouse and paste it in the empty row that you created.
3. “Tywin” is now under “Emily”. Finish the task by deleting the duplicate data row.
4. Finally, we now have a new data set.
- How to Transpose Array in Excel (3 Simple Ways)
- Transpose Rows to Columns in Excel (5 Useful Methods)
- How to Transpose a Table in Excel (5 Suitable Methods)
- Excel Transpose Formulas Without Changing References (4 Easy Ways)
2. Using Mouse and Shift Key
Another easy way to swap single or multiple rows can be done by using the “Shift” key and mouse. Here’s how,
1. Drag your mouse and select one or multiple rows to swap.
- Press and hold the “Shift” key on your keyboard. Now move your cursor to the edge of the two adjacent rows until it turns into this icon.
- Click and hold your mouse and hold the “Shift”. Move your mouse and you will see a gray line appears under the selected row that we want to swap.
Extra Method (Transpose)
Here’s an extra method for you! In this method, we will swap between the rows and columns. Let’s see.
- Select the data range you want to swap and “Copy”
- Select the cell where you want to paste. Right-click on the mouse and select “Paste Special”.
3. Now the new tab is open, click on “Transpose” and click “OK”.
4. And our required swapping is done.
Read More: How to Transpose in Excel (5 Easy Ways)
➤ While swapping rows using method 2, you need to keep holding your mouse key until you complete your swap
➤ When the swapping between rows and columns is done On method 3, remember that this transpose function is static. That means, if you make changes in the source data, the swapped value will not change.
Swapping rows is easy when you follow any one of the three methods that we discussed in this article. I hope this article is useful to you. If you have any thoughts or confusion, you are welcome to comment.
- How to Convert Columns to Rows in Excel (2 Methods)
- Conditional Transpose in Excel (2 Examples)
- How to Transpose Columns to Rows In Excel (6 Methods)
- Transpose Data in Excel (4 Methods)
- VBA to Transpose Array in Excel (3 Methods)
- How to Transpose Duplicate Rows to Columns in Excel (4 Ways)
- How to Convert Columns to Rows in Excel Based On Cell Value
- Transpose Multiple Columns into One Column in Excel (3 Handy Methods)
- How to Reverse Transpose in Excel (3 Simple Methods)