October 20, 2021

How to Swap Rows in Google Sheet

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

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 fix your mouse pointer on any of the row number and then left click & hold the click(here don’t click & hold on the separator line between any two rows then upon dragging it will increase the size of the row instead of moving the rows). The cursor should convert to a hand. Then hold the row numbers with the left mouse button and drag the same over row# 7 and release.

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 once the mouse pointer became a hand, we dragged the row# 5 over 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 columns in Google Sheet.

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

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

Leave a Reply

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