In Spreadsheet.com, it is 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. For instance, in the animation of a simple sales worksheet below, we use copy and paste to create a new row and fill it in with some data to start with. 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 a Row
You can copy a row from the row header, with keyboard shortcuts, or via the Edit menu in the toolbar. In the row reader, right-click on the row header and select Copy from the options, or select the row to be copied, click on Edit in the toolbar and select Copy.
|Copy: Right-click Row Header||Copy: Edit Menu|
To paste the copied row, navigate to the target row header and select Paste (either by right-clicking or from the Edit menu).
You can also use the keyboard shortcuts for copy, by selecting the row to be copied and pressing Ctrl + C (or Cmd + C on Macs). Or the command for paste, by selecting the row to paste into and pressing Ctrl + V (or Cmd + V on Macs).
If you paste a row on top of an existing row, you will overwrite the data in the existing row. In the animation above, to prevent overwriting data we inserted a new empty row before pasting in the copied row.
Also, 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.