Copying a Column

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.

RC-Copy-Paste-Locate.jpg

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 mceclip0.png and paste it into a different column.

You can also find the "Copy" and "Paste" options via the Edit menu in the top menu bar.

M-Copy-Paste-Locate.jpg

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.

Paste-Values-Only-Locate.jpg

Check out our article on inserting or moving columns for other ways to add and move columns, or our article on copying and pasting styles to learn how to move a column's style and not the data in it.