In Spreadsheet.com, copying and pasting columns functions much the same way as in 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. For instance, in the animation of a simple CRM below, we use copy and paste to give our empty column D some data to start with. 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. For instance, to copy the column in the animation below, we select column A, right-click on the column header and select Copy, then navigate to column E, right-click on the column header, and select Paste.
Note: Pasting a column onto an existing column will overwrite the previous data (for instance, the column header in the animation below). Make sure you are okay losing that data or click undo and paste it into a different column.
Alternatively, you can select a column and use the copy (Ctrl + C) and paste (Ctrl + V) keyboard shortcuts. Or via the Copy and Paste commands in the Edit menu.
You can also use the Cut command (keyboard shortcut: Ctrl + X) but cutting a column will remove all data from the selected column that you must paste back in to keep on your worksheet.
How to Paste Values Only
Sometimes, when copying a column with formulas, you only want to copy the output of those formulas. To do this after copying and pasting in the desired column, a Clipboard will appear in the bottom right of the screen, selecting "Paste values only" will convert any formulas to the outputs.
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 details, see our Formula readjustment article.
Copying and pasting in columns from outside the worksheet may not retain formatting, data type, or formulas, see our paste limitation and workarounds details for more information.