Last Updated on October 30, 2023 by Jake Sheridan
In this tutorial, you will learn how to switch rows in Google Sheets
How To Switch Rows In Google Sheets
When working with spreadsheets, you may find yourself needing to switch the positions of certain rows.
For example, you may be keeping track of a to-do list and you want to move a certain priority task to the top of the table.
In this guide, we will give you a few simple tricks you can use to switch the position of rows in Google Sheets. First, we’ll tackle how to swap two adjacent rows with just a few clicks. Next, we’ll explain how to swap the positions of two rows that are further apart from each other.
How To Swap Two Rows in Google Sheets
Here’s how to swap two rows in Google Sheets.
First, we’ll take a look at what to do when you want to switch adjacent rows. In this example, we want to swap the second row with the third row.
Start by clicking on the row header of the top-most row of the two you want to swap.
Next, click and hold your mouse cursor until your cursor turns into a grabbing hand icon.
Drag your mouse icon until the bottom border of the lower row is highlighted.
Release your mouse cursor to apply the swap.
You can also achieve this result by dragging the lower row above the upper row.
Next, we’ll try to switch rows that are not adjacent. In this example, we want to switch rows 3 and 10.
Select one of the two rows you want to swap by clicking on their row number.
Next, use the Copy function by typing the keyboard shortcut Ctrl + C.
Select a row outside your current table and paste the copied row using the keyboard shortcut Ctrl + V.
We’ll come back to this row later.
Next, copy the second of the two rows you want to swap.
Paste the copied row into the original row of the first row we copied.
Select the row we’ve pasted outside the current table. Use the Cut function by typing the keyboard shortcut Ctrl + X.
This guide should be everything you need to switch rows in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to use rows in Google Sheets:
- Move A Row
- Delete Empty Rows
- Group Rows
- Change Row Height
- Number Rows
- Make A Row Float
- How Many Rows Can Google Sheets Handle?
- Add A Row
- Highlight A Row
- Insert Multiple Rows
- Delete Every Other Row
- Delete Rows
- Alternate Row Colors
- Highlight Row Based On Cell
- Select Multiple Rows
- Sum A Row
- Sort Rows
- Resize Rows
- Merge Rows
- Remove Duplicate Rows
- Select Every Other Row
- Duplicate Rows