For small data sets or to quickly move data around existing worksheets, you may want to use copy and paste. For instance, if your customer wants to place the same order they did last month.
How to Copy and Paste Data
There are two ways to copy and paste data in Spreadsheet.com. First, using the keyboard shortcuts Ctrl + C (Copy) and Ctrl +V (Paste). Or Command + C and Command + V for Mac. Second, by using the Copy and Paste options in the Edit menu. You can also use the cut function to remove the data from your source when you copy.
Notes on Pasting
- If you copy and paste data within the same worksheet, all of the cell's formatting, data types, and formulas should be copied exactly, but try to copy the view or worksheet itself if you have trouble.
- If you copy from one Spreadsheet.com worksheet to a different Spreadsheet.com worksheet, make sure you use the Ctrl + C (Copy) and Ctrl +V (Paste) keyboard shortcuts. The cell formatting, data types, and formulas should be retained. You can even use paste values only, to paste the values from formulas.
You can also create a copy of the worksheet and work with that copy.
- If you try to copy from outside of Spreadsheet.com (for example from Excel, Google Sheets, or a text file), most data, formatting, and formula outputs should persist. Data types too, may convert correctly.
If you encounter any trouble, you can overcome any copy and paste errors by importing your spreadsheet.
For large data sets, importing or copying worksheets is often the better way to bring data in. For specific insights into importing, check out our full set of import articles or our Tips for Importing Spreadsheets article.