The simplest way: select, copy, paste
To move or duplicate data from one Excel file to another, select the cells you want, press Ctrl+C (or Cmd+C on Mac), switch to the other file, click where you want the data to land, and press Ctrl+V. That is the whole process for most everyday tasks.
The cells you select stay highlighted with a dotted border after you copy them, so you know what is queued up to paste. If you change your mind, press Escape to clear the selection. If you paste and do not like where it landed, press Ctrl+Z to undo and try again.
Excel remembers only one copied selection at a time. If you copy something else before you paste, the first selection is forgotten. This matters when you are moving data between multiple files — copy one batch, paste it, then go back and copy the next batch.
Key Takeaways
- Select the cells you need, press Ctrl+C to copy, switch files, click the destination cell, and press Ctrl+V to paste.
- Paste Special (Ctrl+Shift+V) lets you paste only the values, formulas, or formatting instead of everything at once.
- If the pasted data does not line up the way you expected, undo with Ctrl+Z and try pasting into a different starting cell.
- Dragging a file icon into an open Excel window opens it without closing what you are already working on, making it easier to copy between files side by side.
Copying entire rows, columns, or sheets
To copy a whole row or column, click the row number on the left (for a row) or the column letter at the top (for a column). The entire row or column highlights in blue. Then copy and paste as usual.
To copy an entire sheet, right-click the sheet tab at the bottom of the window and select "Move or Copy". A dialog box opens. Choose the destination file from the dropdown, pick where in that file the new sheet should go, check the box that says "Create a copy", and click OK. The sheet and all its data, formulas, and formatting move to the other file as a new tab.
If you only want to copy the sheet structure without the data — the column widths, headers, and formatting but not the numbers — copy the sheet first, then delete the rows with data in the new copy.
Paste Special: controlling what actually pastes
Sometimes you want only the numbers, not the formulas. Sometimes you want the formatting but not the data. Paste Special gives you that control. Press Ctrl+Shift+V (or Cmd+Shift+V on Mac) after you copy, and a dialog box opens with options.
The most common choices are: "Values" (numbers only, no formulas), "Formulas" (the opposite — the calculation rules but not the results), and "Formatting" (colors, fonts, borders, but no data). If you paste values into a cell that originally held a formula, the formula is replaced with the number it calculated.
You can also use Paste Special to transpose data — turn rows into columns and columns into rows. Check the "Transpose" box in the dialog, and a row of five cells becomes a column of five cells when it pastes.
What happens when columns are different widths
If you copy data from a narrow column and paste it into a wider column, the data pastes but the column width does not change. The text or numbers land in the new cell at their original width. This is usually what you want — it means the receiving spreadsheet keeps its own formatting.
If you want the pasted data to match the column width of where it came from, use Paste Special and check "Column widths" along with whatever else you are pasting. This is less common, but useful when you are building a copy of a spreadsheet and want it to look identical.
Copying between files that are both open
If you have two Excel files open at the same time, you can see both on screen and copy between them without closing either one. Open the second file normally, then use Alt+Tab (or Cmd+Tab on Mac) to switch between them, or arrange the windows side by side so you can see both at once.
To arrange them side by side on Windows, right-click the taskbar and select "Show windows side by side". On Mac, drag one window to the left edge of the screen until it snaps to half the display, then drag the other to the right half. Now you can select cells in one file, copy, click the other file, and paste without switching windows.
This method is slower than copying and pasting in sequence, but it helps you see whether the data landed in the right place before you move on to the next batch.
Handling merged cells and special formatting
If the cells you are copying are merged (combined into one larger cell), pasting them into a file where those cells are not merged can cause unexpected results. The data may paste into only the first cell of the range, or it may paste across multiple cells depending on how the destination is set up.
Before you paste merged cells, check whether the destination file has merged cells in the same location. If it does not, unmerge the cells in the source file first (select the merged cell, go to the Home tab, click "Merge and Center", and select "Unmerge Cells"). Then copy and paste. You can merge the cells again in the destination file after pasting if you need them merged there.
Conditional formatting — rules that change a cell's color or style based on its value — does not always paste. If you copy a cell with conditional formatting and paste it into a file that does not have that same rule set up, the formatting may not appear. Use Paste Special and choose "Formatting" only if you want to copy the rule itself, but you may need to set it up manually in the destination file.
Copying data from a web page or PDF into Excel
If you want to copy a table from a website or PDF into Excel, select the table on the page, copy it, and paste it into Excel. Most of the time it works — the rows and columns land in the right cells. Sometimes the formatting is messy or the data does not line up the way you expected.
If the pasted data looks wrong, undo and try pasting into a blank area of the spreadsheet first. Then you can clean it up — delete extra rows, fix column widths, remove unwanted formatting — before moving it to its final location. This is usually faster than trying to fix it in place.
For PDFs, copying works best if the PDF is a table or structured text. If the PDF is a scanned image of a document, copying will not work — you would need to type the data in manually or use a tool designed to read scanned documents.
Frequently Asked Questions
What is the difference between copying and cutting?
Copying (Ctrl+C) leaves the original data where it is and makes a duplicate elsewhere. Cutting (Ctrl+X) removes the data from the source and moves it to the destination. After you cut, the original cells are empty. Use cut when you want to move data, copy when you want to keep it in both places.
Can I paste data into multiple cells at once?
Yes. Select all the cells where you want the data to land, then paste. If you copied five cells and select a range of ten cells before pasting, Excel repeats the pattern to fill the space. If you select fewer cells than you copied, only the data that fits in the selection pastes.
Why does my pasted data have extra spaces or line breaks?
Data from web pages or other sources sometimes includes hidden formatting. After you paste, use Find and Replace (Ctrl+H) to search for line breaks or extra spaces and remove them. Search for "^l" (caret and lowercase L) to find line breaks, or use regular expressions if you need more control.
How do I copy formulas without changing the cell references?
When you copy a formula to a new location, Excel automatically adjusts the cell references. If you want the formula to stay exactly the same, use Paste Special and choose "Formulas", then manually edit the formula in the destination cell to use absolute references (add dollar signs: $A$1 instead of A1) before you copy.
Can I undo a paste if I realize it was wrong?
Yes. Press Ctrl+Z when ready after pasting, and the data goes back to where it came from. You can undo multiple times to go back several steps. If you have already saved the file, undo still works as long as you have not closed and reopened the file.