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.
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.
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.
Or, you can access copy and paste options from the Edit menu in the top menu bar.
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.
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.