Copying a Row

 

In Spreadsheet.com, it's easy to copy data in a worksheet by copying and pasting rows.

You can copy and paste rows to quickly move data around, start empty rows with data from other rows, or copy in other rows to apply formatting and formulas.  Like other spreadsheet programs, you can use keyboard shortcuts to copy and paste or use copy and paste functions in the menu.

How to Copy and Paste a Row

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

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

How to Paste Values Only

Sometimes, when copying a row with formulas, you only want to copy the output of those formulas and ignore the formulas themselves or any associated formatting. After you copy and paste your row, a clipboard icon will appear in the bottom right corner of the screen. By clicking on the icon and selecting "Paste values only," all pasted formulas will be converted to their outputs.

Paste-Values-Only-Locate.jpg

Read on through all of our articles on rows to learn more about features like expanding rows and row hierarchies.