March 16, 2021

How to Swap Rows in Excel

In this lesson we will learn how to move and swap rows in Excel.

Move rows means the particular rows will be moved to the specific destination row and the adjacent rows at the direction of movement will be shifted to fill the old position of the moved rows.

The row movement will be considered as swap if the source row will be moved just to it’s adjacent row’s place. In that case as per the above mentioned rule the row next to it will be shifted to the vacant position of the source row which means those two adjacent rows have been swapped. 

Let’s understand this with a simple example. We have the below table containing different type of dresses along with their color and price.

Now we will move the first 2 rows(except header) to the last.

To do that first select both of the rows that is row# 2 & 3. Then place your mouse cursor on the border of the selected rows to the direction of movement. Here we will move row# 2 & 3 downwards hence we placed the mouse pointer to the down border of row# 3 until the mouse pointer converts to the 4-sided arrow cursor as follows.

Now press the Shift key in your keyboard and drag the source rows to the desired place, in our case we have dragged the row# 2 & 3 over to row#7 and released.

Now as you can see below previous row# 2 & 3 now became row# 6 & 7 and previous row# 4 to row# 7 now have been shifted upwards to row# 2 to row# 5.

Now let’s swap between row# 4 & 5. Here we have selected the row# 5 and placed the mouse pointer to the top border as we will move the row# 5 to upward direction. Once the mouse pointer became 4-sided arrow cursor, we have pressed the Shift key and dragged the row# 5 over to row# 4.

Now as you can see below row# 4 & 5 have been swapped since they were adjacent.

You can also check here to know how to swap rows in Google Sheet.

You can also check here to know how to swap columns in Excel.

You can also check here to know how to swap columns in Google Sheet.

Leave a Reply

Your email address will not be published. Required fields are marked *