You can copy and paste columns to quickly move data around, start your empty column with some data, or apply formatting and formulas.
In Spreadsheet.com, copying and pasting columns functions works similarly to other spreadsheet software. You can copy and paste columns to quickly move data around, start your empty column with some data, or apply formatting and formulas. Like other spreadsheet programs, you can use keyboard shortcuts to copy and paste, or find copy and paste functions in the menu.
How to Copy and Paste a Column
There are multiple quick ways to copy and paste columns. You can copy a column by right clicking on the column header or clicking the downward arrow to the right of the column name and selecting “Copy” from the dropdown. Then, select the column in which you want to past and repeat the process, this time selecting "Paste" from the dropdown.
Pasting a column onto an existing column will overwrite the previous data. Make sure you are okay losing that data or are pasting into a new blank column. Or, if you accidentally override important data, click undo and paste it into a different column.
You can also find the "Copy" and "Paste" options in the document menu by navigating to the Edit submenu.
How to Access the Document Menu
To access the document menu,
- Open the document dropdown by clicking the arrow to the right of the document name
- Select "Menu..." from the dropdown
Alternatively, you can use keyboard shortcuts to copy (Ctrl + C) and paste (Ctrl + V) columns.
The Cut command – found in the same locations as copy and paste or by using the shortcut Ctrl + X) – will simultaneously remove the selected data from your worksheet and copy it to your clipboard so it can be pasted elsewhere.
Data Types, Formulas, and Formatting When Copying and Pasting
When pasting a column from inside the same worksheet, data type and formatting is retained. For instance, pasting a column with the Date data type into a column with the Automatic data type will change the column to the Date data type.
Formulas are also retained, but cell references may need to be adjusted. For more information, see our article on Formula Readjustment.
Copying and pasting in columns from outside the worksheet may not retain formatting, data type, or formulas. For more information, see our article on Adding Data to Existing Worksheets via Copy and Paste.
How to Paste Values Only
Sometimes, when copying a column 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 column, 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.