Moving Rows

  • Updated

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.

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.

RC-Copy-Paste-Locate.jpg

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 in the top menu bar.

M-Copy-Paste-Locate.jpg

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 mceclip0.png 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.

Copy-Paste-Row.gif

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.