Google Sheets: How to Duplicate Columns

To duplicate a column in Google Sheets, click its letter at the top, copy it with Ctrl+C (Command+C on a Mac), then select a destination column and paste with Ctrl+V (Command+V). If you need to keep existing columns rather than overwrite one, insert a blank column first, then paste the copy into it.

What duplicating a column means

A duplicated column is a second set of cells based on the original. Depending on how you copy and paste, that copy can include values, formulas, and formatting. The duplicate is usually independent: changing a pasted value does not automatically change the source value. If you want a second column that always reflects the original, use a formula instead of an ordinary copy.

It also helps to distinguish duplicating a column from finding duplicate entries. Copying a column creates another column of the same data; it does not remove repeated names, dates, or IDs. Google Sheets has separate tools for those tasks, and the right method depends on whether you want another copy, a live reference, or a cleaned list.

Copy a column with the mouse and keyboard

For a straightforward duplicate in the same sheet, use the column letters rather than selecting only the cells you can see. This selects the whole column, including blank cells below the current data, and makes it less likely that you will miss rows when the sheet grows.

Click the letter at the top of the column you want to copy, such as C.
Copy it with Ctrl+C on Windows or ChromeOS, or Command+C on a Mac. You can also use Edit > Copy.
Click the letter of the destination column.
Paste with Ctrl+V or Command+V, or choose Edit > Paste.

Pasting into a column that already contains information replaces the cells in the pasted range. Check the destination before you paste. If you paste an entire column, you can overwrite data farther down than the visible rows, so inserting a new column is safer when the destination has anything you need to keep.

Insert a new column so nothing is overwritten

To put a duplicate beside its source without replacing another column, first copy the source, then create space at the intended position. For example, to duplicate column C immediately to its right, copy C, right-click the D column letter, and choose Insert 1 column left. Click the letter of the newly inserted blank column and paste. You can use Insert 1 column right from the column-letter context menu when that is the position you need.

Google Sheets shifts existing columns to make room. Review formulas and references after an insertion, especially in a workbook where other formulas depend on column positions. Inserting a column is different from pasting over a column: it changes the sheet structure, while a paste replaces cell contents in the selected area.

You can also insert a column from the menu: select a column, then use Insert and choose the option to add a column to the left or right. The wording of the insert option depends on the selected column. If you are uncertain which direction it will add space, use the column-letter context menu and read the option before choosing it.

Duplicate a column in another sheet

To copy a column to a different tab, select its letter and copy it, open the destination sheet tab, click the destination column letter, and paste. If you want it at the beginning of the destination sheet, select column A. To preserve existing data, insert a blank column at the destination first.

When a copied formula refers to cells on the original sheet, check what happens after pasting. References can adjust based on the new location, and cross-sheet references may continue pointing to the original tab. If the copy is intended as a snapshot, paste values only instead. If the destination is in a different spreadsheet file, you can copy the cells and paste them into the other open spreadsheet, but confirm that formulas and formatting have transferred as intended.

What gets copied: values, formulas, and formatting

A regular copy-and-paste operation can carry more than the displayed text. It may include formulas and cell formatting, and other cell settings can also be relevant. For instance, a column of dates may look different if its number format is not preserved. After pasting, inspect a few representative cells rather than assuming the duplicate is identical in every respect.

Google Sheets offers paste-special choices under Edit > Paste special. Use Values only when you want the current calculated results without formulas. Use Format only when you want the appearance without replacing the destination values. Formula only is useful when the formulas matter but the source formatting does not. These choices help when the destination needs to keep some properties and change others.

Formulas deserve special attention because relative references can move when copied. Suppose D2 contains a formula that multiplies B2 by C2. Copying D2 one column to the right normally adjusts the relative references to C2 and D2. A reference with dollar signs, such as $B$2, is absolute and stays fixed when copied. If the duplicated formula must continue pointing to the same inputs, check whether its references should be absolute, relative, or mixed.

Make a live duplicate with a formula

If the second column should update whenever the source changes, enter a reference formula instead of pasting a static copy. For example, with the original data in column A and the destination in column B, enter =A:A in B1. In Google Sheets, the result can expand down the destination column, provided the cells it needs are empty. Do not put the formula in column A, because that would make it refer to its own column.

A live reference is useful for a display or reporting tab, but it is not the same as a separate editable copy. The referenced results depend on the source, and typing into cells occupied by the expanded result can block it. If you need to change individual values independently, copy and paste instead. For a more selective mirror, reference a range such as =A1:A100 rather than the full column.

Common problems and how to avoid them

The original data was replaced. You pasted into an occupied destination. Undo immediately with Ctrl+Z or Command+Z if the paste was accidental, then insert a blank column and try again.
The result looks different. Number formats, fonts, borders, or conditional formatting may not behave as expected in the new location. Inspect the destination and use Edit > Paste special for more control.
Formulas show unexpected results. Relative cell references may have adjusted after copying. Click a formula cell and inspect its references; use dollar signs for references that must remain fixed.
The live formula does not expand. Clear any existing contents in the cells below the formula that it needs to fill. Also confirm that the source and destination are different columns.
Some rows seem missing. A filter can hide rows on screen. Check the filter state and the copied destination instead of assuming hidden rows were removed from the data.

For a large or important sheet, make a copy of the spreadsheet before structural edits. Also check for protected ranges, merged cells, or formulas that depend on column positions; those features can make a seemingly simple paste or insertion behave differently from what you intended.

Duplicating columns is not removing duplicate data

If your goal is to remove repeated records, making a second column is not the solution. To remove duplicate rows based on selected data, select the relevant range and use Data > Data cleanup > Remove duplicates. Review which columns are selected in the dialog: choosing too few or too many columns can change what Sheets considers a duplicate row. Consider copying the data to a separate tab first if you need to retain the original list.

For a separate list of distinct values that updates from a source range, the Google Sheets UNIQUE function may be a better fit. For example, =UNIQUE(A2:A) returns unique entries from that range. That produces a distinct list, not a duplicate column, and it does not preserve the source column’s full formatting. Choose based on the result you actually want.

Frequently Asked Questions

How do I duplicate a column without overwriting another one?
Copy the source column, insert a blank column where you want the duplicate, then select the new column and paste. This makes room instead of replacing the contents of an existing column.

Can I duplicate a column in Google Sheets on a Mac?
Yes. The steps are the same in a browser. Use Command+C and Command+V instead of Ctrl+C and Ctrl+V, or use the Edit menu and column-letter context menu.

Does a duplicated column update when I edit the original?
Not if you used ordinary copy and paste. That creates a separate copy. For a column that reflects the source, enter a reference such as =A:A in a different, empty column.

How do I copy only the results, not the formulas?
Copy the column, select the destination, and choose Edit > Paste special > Values only. This keeps the displayed results rather than copying the formulas that produced them.

What is the difference between duplicate columns and Remove duplicates?
Duplicating columns creates another copy of a column. Data > Data cleanup > Remove duplicates is for removing repeated rows from a selected range. It does not create a second column.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.