Unlike columns, rows cannot be explicitly relocated.
However, you can achieve the same goal by either copying and pasting a row's data, or by creating an automation to automatically move rows.
This article features Spreadsheet.com's Alumni Directory template. Explore the Template Gallery to find ready-to-use templates in over 20 different categories, or learn more about starting a new workbook from a Spreadsheet.com template.
Moving Rows with Copy and Paste
The simplest way to move a row from one location to another is by copying and pasting it. Begin by inserting a new row in the location where you want to move your data to.
There are multiple ways to copy a row. You can select the row you want to copy and right click, then select "Copy" from the dropdown. Select the row in which you want to paste your copied row and select "Paste" from the same dropdown to paste your copied row into its new location.
Using Cut instead of Copy will simultaneously delete the selected data from a location and copy it to your clipboard.
Or, you can access copy and paste options from the Edit menu.
Pasting a row onto an existing row will overwrite the previous data. Make sure you are okay losing that data or are pasting into a new blank row. Or, if you accidentally override important data, click undo and paste it into a different row.
You can also copy and paste rows via keyboard shortcuts Ctrl + C (or Cmd + C on Macs) and Ctrl + V (or Cmd + V on Macs), respectively.
Formatting and Formulas When Copying and Pasting
If you paste rows from the same worksheet, the pasted format will match the copied format. However, pasting rows into new worksheets will match the worksheet's existing formatting and may erase entries or formatting.
Most formulas should automatically remap cell references even after you insert a row or rows. However, some formulas may be impacted by inserting a new row and may need to be adjusted.
For more details, see our article on Formula Readjustment.
Moving Rows with Automations
Depending on the circumstances, you may also wish to set up a one-time or a recurring automation that triggers a move row action. See our Introduction to Automations for complete details on setting up an automation.
See all of our articles on automations for more insight into how to set up and use automations.