How to Copy and Paste a Whole Column in Excel Easily

How-to basics · Updated November 20, 2026

To copy a whole column in Excel, click its letter at the top of the worksheet, press Ctrl+C, click the letter of the destination column, and press Ctrl+V. This copies the entire column, including its cell contents and formatting, so check that the destination does not contain anything you need to keep. The instructions below are for Excel for Microsoft 365 on Windows; Mac and web shortcuts are noted where they differ.

What You’ll Need

  • An Excel workbook open to the worksheet containing the column you want to copy.
  • A destination column in the same worksheet, another worksheet, or another workbook.
  • Permission to edit the destination sheet. If the sheet is protected, you may need its password or the workbook owner’s help.

You do not need to select individual cells or know how many rows contain data when you want the entire worksheet column. Excel columns have a fixed number of rows, so selecting the letter copies the full column, not just the visible entries.

Step-by-Step

  1. Open the source worksheet. If the column is in a different worksheet or workbook, open both locations and make sure you can see the source column. If you are copying between workbooks, leave both workbooks open while you copy and paste. For a column on another sheet in the same workbook, you can switch sheets after copying.
  2. Identify the column to copy. Look at the letters across the top of the worksheet, such as A, B, or C. Click the letter above the column you want. The whole column should become highlighted, and Excel should show the column letter as selected. Do not click a single cell if your intention is to copy every row in that column.
  3. Copy the selected column. Press Ctrl+C on Windows. A moving dashed outline, sometimes called marching ants, appears around the selection. You can also choose Home > Copy on the ribbon or right-click the selected column and choose Copy. Keep the selection active; clicking elsewhere before copying would change what is selected.
  4. Go to the destination. For a destination on the same sheet, find the column where you want the copy to begin. For a different sheet in the same workbook, click its sheet tab while the copied-column outline remains visible. For another open workbook, switch to that workbook, then choose the destination sheet. Copying first and switching sheets is normal; the clipboard selection remains available.
  5. Select the destination column. Click the letter at the top of the column where the copied column should go. If you are pasting into a different workbook, select the destination column letter there. This tells Excel to place the copied full column at that position. You can instead click a particular destination cell if you want to paste the copied column starting at that row, but doing so is not the same as replacing an entire column and can leave existing content above or below it.
  6. Paste the column. Press Ctrl+V, or choose Home > Paste. Excel places the copied cells in the destination. A full-column paste includes blank cells as well as populated cells, so it can replace content farther down the destination column than you expect. Review the result before continuing with other edits.
  7. Check the result and finish the copy operation. Confirm that the expected values, formulas, and formatting appeared in the destination. Press Esc to clear the moving dashed outline when you are done. If the column contains formulas, check a few of them in the formula bar: references may adjust to the new location, which is usually what Excel does for relative references.

On a Mac, use Command+C to copy and Command+V to paste. In Excel for the web, use Ctrl+C and Ctrl+V on Windows or Command+C and Command+V on a Mac, subject to browser shortcut behavior. You can also use the Home ribbon’s Copy and Paste buttons if a keyboard shortcut is intercepted by the browser. The column-letter selection and general paste process are otherwise similar.

If the source and destination columns are on the same worksheet, pasting over a different column replaces its existing cell contents in the pasted area. It does not automatically create a new blank column. If you need to add a column without overwriting existing data, insert a blank column first: right-click the destination column letter and choose Insert, then paste into the new column.

Common Mistakes

  • Selecting only a cell or a data range. Clicking a cell and pressing Ctrl+C copies only that cell. Dragging over a range copies only those rows. To include every row, click the column letter. If you only want the entries with data, select the smaller range instead; a whole-column copy can carry unwanted formats or formulas in otherwise blank rows.
  • Pasting over information by mistake. A full-column paste can overwrite existing values, formulas, and formatting in the destination. Excel may not display a warning first. Check the destination column before pasting, or insert a new column if the original data must remain intact.
  • Expecting column width to copy with the cells. A normal paste copies cell contents and formatting, but the destination column width may stay as it was. If matching widths matters, copy the source column, select the destination, then use Home > Paste > Paste Special > Column widths. Menu wording or ribbon layout can vary slightly with Excel updates.
  • Assuming formulas will stay identical. Relative references usually shift based on the new location. A formula referring to B2 may refer to C2 after being copied one column to the right. Absolute references marked with dollar signs, such as $B$2, remain fixed. Check important formulas after pasting.
  • Forgetting hidden or filtered rows. Copying a full column includes its hidden rows and cells, not just the rows currently visible through a filter. If you need only visible filtered results, select the relevant range, then use Home > Find & Select > Go To Special > Visible cells only before copying.

Tips

  • Choose the paste method that matches your goal. Standard Ctrl+V copies values, formulas, and formatting. To paste values without formulas, copy the source, select the destination, and choose Home > Paste > Values. This is useful when you want fixed results rather than formulas that recalculate or change references.
  • Use Paste Special for other parts of a column. After copying, Home > Paste opens options for pasting formats, formulas, or other attributes. For example, choose Formats when the destination should adopt the source’s appearance without replacing its values. Use Column widths when you specifically want the source width. Review the menu options available in your Excel version before choosing.
  • Keep the original and the copy clear. If you are making a backup, give the duplicate column a clear heading or use a new worksheet. If you simply need to move data rather than duplicate it, use Ctrl+X and Ctrl+V instead of Ctrl+C and Ctrl+V; cutting removes the source after the move.
  • Copy between workbooks carefully. If you copy a formula to another workbook, it may continue to refer to the original workbook, depending on the formula and where its referenced cells are. If the destination needs independent results, paste values. Save the destination workbook after checking the pasted content.
  • Use the ribbon if shortcuts do not work. In some remote desktop sessions, browsers, or keyboard layouts, Ctrl+C and Ctrl+V may be handled by another app. Select the column and use Home > Copy, then choose the destination and Home > Paste.

Troubleshooting

Nothing appears after you paste: Make sure you copied the source column first and that the moving dashed outline is still visible. Select the destination and try Home > Paste. If you switched to another workbook, confirm it is open and that the intended sheet is active. In Excel for the web, browser permissions or shortcut handling can interfere, so try the ribbon buttons.

Excel says the destination is not the same size: This can happen if you copied a full column but selected a smaller, differently sized range or a non-matching area. For a full-column copy, click the destination column letter before pasting. If you only need a few rows, select a source range of the same size and paste into a destination range with matching dimensions.

The wrong cells were replaced: Press Ctrl+Z immediately to undo the paste, as long as you have not performed actions that prevent undo. Then verify the destination column letter and inspect its existing contents. If you intended to insert rather than replace, undo first, insert a blank column, and paste into it.

Formulas show unexpected results: Click a pasted formula cell and inspect the formula bar. References may have shifted because they are relative. If the formula should always refer to the same source cell, edit the original formula to use absolute references where appropriate, then copy again. If you only need the displayed results, undo if needed and paste using Home > Paste > Values.

Formatting or column width does not match: A regular paste may not copy the width. Use Paste Special > Column widths for width, or Paste Special > Formats for formatting. If the sheet is protected, ask the workbook owner to allow editing or unprotect the sheet before retrying. Be cautious with merged cells, since they can make the destination selection incompatible with the copied column.

The paste includes rows you did not expect: A whole-column copy includes all rows, including hidden and filtered-out rows. Undo the paste if necessary. Then select only the data range you need. For filtered data, use Go To Special and Visible cells only on the selected range before copying, and confirm the selection before pasting elsewhere.

Frequently Asked Questions

Does copying a whole column include blank cells?
Yes. Selecting a column letter selects the entire worksheet column, including blank cells. When pasted, blank source cells can replace content in matching destination positions, so use a smaller range if you want to limit the operation.

Can I copy a column to another worksheet?
Yes. Select the source column letter, copy it, click the destination sheet tab, select the destination column letter, and paste. Excel can also paste between open workbooks. Check formulas afterward because references may continue to point to the original sheet or workbook.

How do I copy a column without its formulas?
Copy the column, select the destination, and choose Home > Paste > Values. This pastes the calculated results rather than the formulas. It does not preserve all source formatting, so use a separate formatting paste if you need the appearance too.

How can I copy only the data in a column?
Select just the cells containing the data, rather than clicking the column letter, then copy and paste. You can select the first data cell and extend the selection to the last required row. Check the range before copying so you do not include a heading or unwanted blank rows.

Does a copied column keep the same width?
Not necessarily with a standard paste. To copy width, copy the source column, select the destination, and use Home > Paste > Paste Special > Column widths. You can then paste the cell contents and formatting separately if needed.

Can I copy a column using the keyboard only?
Yes. Select a cell in the column and press Ctrl+Space to select the column, then press Ctrl+C. Select the destination column and press Ctrl+V. If you want a straightforward full-column selection, clicking the column letter is often easier to verify. On Mac, use Command for copy and paste; selection shortcuts can differ by Excel version and keyboard layout.

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.