How to Copy a Column in Excel Without Losing Any Data

How-to basics · Updated November 20, 2026

To copy a column in Excel for Microsoft 365 on Windows, click its lettered header, press Ctrl+C, select the destination column header, and press Ctrl+V. To copy only part of a column, select the cells you need first. Copying leaves the original in place, but pasting into occupied cells replaces their contents, so check the destination before you paste.

You can copy a whole column, a range of cells, or only the values from formulas. The steps below explain which method to choose and how to avoid changing formulas or overwriting information by mistake.

What You’ll Need

  • An open Excel workbook containing the column you want to copy.
  • A destination in the same worksheet, another worksheet, or another workbook. If the destination contains information you need, choose an empty area or insert a new column rather than pasting over it.
  • For a copy to another workbook, have both workbooks open so you can switch between them.

Step-by-Step

  1. Decide what you want to copy. Use the column header if you need every cell in the column, including blank cells and cells outside the visible part of the sheet. To copy just a table field or a section, select only the relevant cell range instead. For example, if names are in column B from rows 2 through 40, select B2:B40 rather than the B header. A smaller selection is often safer when the sheet contains other data below the table.
  2. Select the source. For a whole column, click its letter at the top of the worksheet, such as C. Excel highlights the column. For a range, click the first cell, hold the mouse button, and drag to the last cell, or click the first cell and Shift-click the last. You can also select a range by clicking the Name Box to the left of the formula bar, typing a range such as B2:B40, and pressing Enter.
  3. Copy the selection. Press Ctrl+C on Windows. You can also choose Home > Copy on the ribbon, or right-click the selection and choose Copy. A moving dashed outline normally appears around the copied cells. This is a copy operation: the original data remains where it is. Do not press Ctrl+X unless you mean to move the column and remove it from its original location.
  4. Choose where the copy should go. To paste a whole column, click the lettered header of an empty destination column. To paste a selected range, click the top-left cell where the copied range should begin. For example, copying B2:B40 and clicking D2 places the first copied cell in D2 and the last in D40. Confirm the destination will not overwrite information you want to keep.
  5. Paste the copy. Press Ctrl+V, choose Home > Paste, or right-click the destination and choose Paste. Excel pastes the copied cells and usually carries over their formatting and formulas. If you copied an entire column, paste it into another column header; if you copied a range, start at a single destination cell.
  6. Insert a copied column instead of replacing one. If you need to keep the existing columns and make room for the copy, copy the source column, right-click the header of the column where the new one should appear, and choose Insert Copied Cells. This inserts the copied column and shifts existing columns to the right. Check the resulting layout, especially if the sheet contains tables, charts, or formulas that refer to the affected columns.
  7. Choose a paste option if a normal paste is not right. After copying, select the destination and use Home > Paste to open the paste choices. Select Values to paste the displayed results without the source formulas, or select Formulas if you want formulas without carrying over the original formatting. The available choices depend on what you copied. If you need the exact appearance, use the regular Paste option rather than Values.
  8. Check the result. Look at the first and last pasted cells and compare a few entries with the source. Check number formats, dates, formulas, and column width. Copying cells does not automatically copy the source column’s width in every paste method; if the pasted column looks cramped, use Home > Format > Column Width or AutoFit Column Width to adjust it. When finished, press Esc if the moving outline remains and you no longer need to paste again.

On a Mac, use Command+C to copy and Command+V to paste; the ribbon commands and the general selection steps are similar. In Excel for the web, use the column header or cell range and the Home tab’s Copy and Paste commands, or the browser-supported keyboard shortcuts. Some paste choices and context-menu commands can vary slightly by platform, so use the ribbon if a shortcut behaves differently.

Common Mistakes

  • Pasting over useful data: A normal paste replaces cells at the destination. Excel may show a warning in some situations, but do not rely on one. Check the destination first, or use Insert Copied Cells when the existing columns need to move aside.
  • Selecting the whole column when only a table range is needed: A full-column copy includes cells beyond the visible table, including blank cells and data farther down the sheet. This can make a workbook larger or cause unexpected results when pasting near other content. Select a specific range when you only need the table entries.
  • Using Cut instead of Copy: Ctrl+X marks cells to be moved. Pasting them elsewhere changes their original location, which can break a layout or leave a gap. Use Ctrl+C when you want the source to remain unchanged.
  • Expecting formulas to stay identical: Excel normally adjusts relative references when formulas are pasted in a new location. For example, a formula that refers to the cell immediately to its left may be changed to refer to the new cell immediately to its left. Use Values when you want fixed results, or inspect formulas after pasting.
  • Assuming filtered or hidden rows are excluded: Copying a whole column can include cells that are hidden or not shown by a filter. If you need only visible cells, select the visible range carefully in desktop Excel and use Home > Find & Select > Go To Special > Visible cells only before copying. Review the selection before pasting, especially when the filtered data is important.
  • Expecting column width to come along automatically: Cell contents and formatting can paste while the destination keeps its own width. Adjust the destination width separately if text is cut off or dates display as number signs.

Tips

  • Use the column header for a whole-column copy. Clicking the letter is more reliable than dragging down the visible rows when the source needs to include the entire column.
  • Use a deliberate destination. If the copy is for a temporary comparison, paste into a blank area or a new worksheet. To make a new sheet, click the plus button beside the sheet tabs, then paste into the desired starting cell.
  • Paste values for a fixed snapshot. This is useful when you want the current displayed numbers or text without formulas that may recalculate. Remember that values-only paste may not preserve the source’s formatting, so check dates, percentages, and decimal places.
  • Keep formula behavior in mind. Relative references usually adjust to the new position, while absolute references marked with dollar signs, such as $A$1, remain fixed. If a copied formula produces an unexpected result, click the pasted cell and inspect the formula bar.
  • Use Undo promptly if the result is wrong. Ctrl+Z on Windows (Command+Z on Mac) reverses a recent paste in most cases. Undo is less dependable after later edits or certain external actions, so check the result immediately.
  • Copy between workbooks with care. When you paste formulas into another workbook, Excel may retain references to the original workbook. If you only need the displayed results, paste values, then verify that the numbers and formatting are suitable.

Troubleshooting

  • Nothing appears after pressing Ctrl+V: Click a destination cell or header first, then try again. Confirm that the copied outline is still visible; if you copied something else in the meantime, repeat the copy. In Excel for the web, a browser or device may limit clipboard shortcuts, so try the Home tab’s Paste command.
  • Excel says the copy and paste areas are different sizes: This can happen if you select multiple destination cells that do not match the copied range. For a range copy, click only the top-left destination cell and paste. For a whole column, select one destination column header.
  • The copied formulas show different answers: Click a pasted formula cell and compare its references with the source formula. Excel may have adjusted relative references for the new location. If you want the source’s current results rather than formulas, undo the paste and repeat it using Home > Paste > Values.
  • The paste is blocked or incomplete: Check whether the worksheet is protected, whether the destination is part of a merged-cell area, or whether a table or filtered selection is restricting the operation. If the sheet is protected, you may need permission to unprotect it. Try copying a plain cell range to a blank area to identify whether the issue is with the source selection or the destination.
  • Text or numbers look different: The destination may have its own number format, or the column may be too narrow. Try a regular paste if you used Values, then use Home > Format > AutoFit Column Width. If a number appears as ####, widening the column often reveals the value; it does not usually mean the value was deleted.
  • You pasted into the wrong place: Press Ctrl+Z on Windows or Command+Z on Mac as soon as possible, then select the correct destination and paste again. If you have made several changes since the paste, save a separate copy of the workbook before attempting further recovery.

Frequently Asked Questions

How do I copy a column in Excel without changing the original?

Click the column letter, press Ctrl+C, then click the destination column letter and press Ctrl+V. Copying leaves the source in place. Avoid Ctrl+X, which is used to cut and move cells.

How do I copy only part of a column?

Select the required cells, such as A2:A25, copy them, and click the first destination cell before pasting. This copies only the selected range rather than every row in the column.

How can I copy a column but not its formulas?

Copy the source, select the destination, then choose Home > Paste > Values. The destination receives the current results instead of the formulas. Check number formats afterward, particularly for dates, percentages, and currency.

Can I copy a column to another worksheet or workbook?

Yes. Copy the column, switch to the other sheet or open workbook, select the destination column header, and paste. When copying formulas to a different workbook, check whether they refer back to the original file; use Values if you want results without those formula links.

How do I copy a column without overwriting the next one?

Copy the source column, right-click the destination column header, and choose Insert Copied Cells. Excel inserts the copy and shifts the existing columns rather than replacing their contents. Verify that formulas and the sheet layout still work as intended.

Does copying a column also copy its width?

Not necessarily. A normal paste may copy cell contents and formatting while leaving the destination column’s width unchanged. Adjust it with Home > Format > Column Width or AutoFit Column Width if needed.

Related

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.