In this tutorial, you will learn how to move a row in Google Sheets.
If the rows of your Google Sheet are out of order, don’t worry, there’s a simple way to move rows in Google Sheets with just a few clicks.
Read on to learn how
Moving a Single Row
Find the row you want to move and click on the row number to the left of the row to select the row
Click and drag on the row number to move the row up or down in the sheet. A wide grey line will move up and down between the rows to show you where the row will go as you move
Release the mouse when the grey line is in the right location to move the row to that location
Moving Multiple Rows
You can also move multiple rows at the same time using the same method described above by following these steps
Select the first row you want to move by clicking on the row number
Hold down the Shift key on your keyboard and select the last row. Both selected rows and all rows between will be selected
Click and drag on the selected row numbers to move them as described for a single row
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to move a row in Google Sheets. Want more? Check out all the Google Sheets Tutorials.