The fastest way to copy a column
Click the column letter at the top — the A, B, C, and so on — to select the entire column. The whole column turns blue or highlighted. Then press Ctrl+C on Windows or Command+C on Mac. The column is now copied to your clipboard.
To paste it somewhere else, click the column letter where you want the data to go, then press Ctrl+V (Windows) or Command+V (Mac). Excel pastes the entire column in that location. If you want to paste into a specific cell instead of replacing a whole column, click that single cell and paste — Excel will paste starting from that cell and moving down and to the right.
If you only need part of a column — say, rows 5 through 20 — click the first cell you want, hold Shift, and click the last cell. Then copy and paste as usual. This method works the same way whether you're using Excel on Windows, Mac, or the web version.
Key Takeaways
- Click the column letter to select an entire column, then press Ctrl+C or Command+C to copy it.
- Paste into a new location by clicking a column letter or single cell and pressing Ctrl+V or Command+V.
- To copy only part of a column, click the first cell, hold Shift, click the last cell, then copy and paste.
- Excel pastes formulas and formatting along with the data — if you want only the values, use Paste Special instead.
- You can copy multiple columns at once by clicking the first column letter, holding Shift, and clicking the last column letter you want.
Copying multiple columns at the same time
If you need to copy more than one column, select them all before copying. Click the first column letter, then hold Shift and click the last column letter in the range you want. All the columns between them turn highlighted. Press Ctrl+C or Command+C, then click where you want to paste and press Ctrl+V or Command+V.
You can also select non-adjacent columns — columns that are not next to each other. Click the first column letter, then hold Ctrl (Windows) or Command (Mac) and click each additional column letter you want. All of them highlight. Copy and paste as usual. Excel will paste them in the same pattern, maintaining the gaps between them.
When Excel pastes more than you want
When you copy and paste a column, Excel copies the data, the formulas, and the formatting — the colors, fonts, borders, and number formats. Sometimes you only want the numbers or text, not the formulas or the colors. That is when you use Paste Special.
After you copy a column, right-click the cell or column where you want to paste and select Paste Special. A dialog box opens with options. Click Values to paste only the numbers or text without formulas. Click Formats to paste only the colors and fonts without the data. You can also paste formulas only, or transpose the data so a column becomes a row.
On a Mac, the keyboard shortcut for Paste Special is Ctrl+Command+V. On Windows, it is Ctrl+Shift+V. Using the keyboard shortcut is faster than right-clicking if you paste special often.
Copying a column to a different sheet
You can copy a column from one sheet to another sheet in the same workbook. Copy the column the usual way — click the column letter and press Ctrl+C or Command+C. Then click the sheet tab at the bottom of the screen to switch to the other sheet. Click the column letter or cell where you want to paste and press Ctrl+V or Command+V.
If the column contains formulas that refer to cells in the first sheet, Excel updates those references automatically when you paste into the new sheet. If you do not want the formulas to change, use Paste Special and choose Values instead. This pastes only the numbers or text, not the formulas.
Undoing a paste if you made a mistake
If you paste a column in the wrong place or paste over data you wanted to keep, press Ctrl+Z (Windows) or Command+Z (Mac) when ready. Excel undoes the paste and restores what was there before. You can undo multiple times — each press of Ctrl+Z or Command+Z takes you back one step.
Excel keeps a history of your recent actions. If you undo too far, press Ctrl+Y (Windows) or Command+Y (Mac) to redo. You can also click the undo or redo buttons in the toolbar at the top of the screen — they look like curved arrows pointing left and right.
Copying a column in Excel Online
If you are using Excel through a web browser — the version at office.com — the steps are the same. Click the column letter to select it, press Ctrl+C or Command+C, click where you want to paste, and press Ctrl+V or Command+V. Right-click to access Paste Special the same way.
The web version works slightly slower than the desktop version, especially with very large columns. If you are copying thousands of rows, the desktop version of Excel may respond faster. Otherwise, the process is identical whether you are on a computer or using Excel in your browser.
Frequently Asked Questions
Can I copy a column and paste it as a row?
Yes, using Paste Special. After you copy the column, right-click and select Paste Special. Check the box labeled Transpose, then click OK. Excel flips the column so it becomes a row, with the first cell of the column becoming the first cell of the row.
What happens if I copy a column with formulas?
Excel copies the formulas and adjusts the cell references automatically. If a formula in column A refers to cell B5, and you paste into column C, the formula in column C will refer to cell D5 instead. If you want the formula to stay exactly the same, use Paste Special and choose Formulas, then manually check the references.
Can I copy a column from one Excel file to another?
Yes. Open both files, copy the column from the first file the usual way, switch to the second file, and paste. The column pastes with its data and formatting. If the column contains formulas that refer to the first file, those references may break in the second file.
How do I copy a column without the header row?
Click the first cell below the header, then hold Shift and click the last cell in the column. This selects only the data, not the header. Copy and paste as usual. The header stays in the original column.