The basic copy and paste method

Copying and pasting in Excel works the same way as in most programs: select what you want, copy it, click where you want it, and paste. The fastest way is to use keyboard shortcuts. Select the cells you need by clicking and dragging, then press Ctrl+C (or Cmd+C on Mac) to copy. Click the cell where you want the data to go and press Ctrl+V (or Cmd+V on Mac) to paste.

If you prefer using the menu, select your cells, then go to the Home tab and click Copy. Click your destination cell and click Paste. The keyboard method is faster once you get used to it, especially if you are moving data around frequently.

When you paste, Excel shows a small clipboard icon next to the pasted cells. You can press Escape to clear the copy selection, or just click somewhere else and it will disappear on its own.

Key Takeaways

  • Use Ctrl+C to copy and Ctrl+V to paste (Cmd+C and Cmd+V on Mac), which is faster than using the menu.
  • Paste Special lets you paste only the values, formulas, or formatting instead of everything at once, which is useful when you do not want to overwrite existing formulas.
  • You can paste data across multiple cells at once by selecting the range where you want it to go before pasting.
  • Copying a cell with a formula adjusts the formula automatically for each new row or column, unless you lock the cell reference with dollar signs.

Selecting what to copy

You can copy a single cell, a row, a column, or a block of cells. Click on a cell to select just that one. To select a range, click on the first cell and drag to the last one you want. You can also click the first cell, hold Shift, and click the last cell in the range you want.

To select an entire row or column, click the row number on the left side or the column letter at the top. To select multiple rows or columns that are next to each other, click the first one and Shift+click the last one. If the rows or columns are not next to each other, hold Ctrl (or Cmd on Mac) and click each one separately.

You can also select all cells in the sheet by pressing Ctrl+A, though this is rarely what you actually want to do.

Paste Special and when to use it

Regular paste copies everything: the data, the formulas, the colors, the borders, all of it. Sometimes you only want part of that. Paste Special lets you choose what gets pasted. Press Ctrl+Shift+V (or Cmd+Shift+V on Mac) after copying, and a dialog box appears with your options.

The most common use is pasting values only. If you copy a cell that contains a formula, regular paste will paste the formula itself. If you want just the result that the formula calculated, use Paste Special and choose Values. This is useful when you are moving data between sheets or combining information from different sources and you do not want formulas to break.

Other Paste Special options include Formulas (the calculation rules without the formatting), Formatting (colors and borders without the data), and Transpose (which flips rows and columns so a horizontal list becomes vertical). You can also choose whether to skip empty cells, which is helpful when you are pasting over existing data and want to keep some of it.

Pasting into multiple cells at once

If you copy a single cell and want to paste it into many cells, you do not have to paste one at a time. Copy the cell, then select the entire range where you want it to go, and paste. Excel will fill all the selected cells with the same data.

If you copy a range of cells and paste it into a larger selection, Excel will repeat the pattern to fill the space. For example, if you copy three cells and select nine cells to paste into, the three cells will repeat three times.

You can also use the fill handle, the small square at the bottom right corner of a selected cell. Click and drag it down or to the right to copy the cell into adjacent cells. This is faster than copy and paste for small amounts of data.

How formulas change when you copy them

When you copy a cell that contains a formula, Excel automatically adjusts the formula for the new location. If a cell contains =A1+B1 and you copy it down one row, the new cell will contain =A2+B2. This is called a relative reference, and it is usually what you want.

Sometimes you want the formula to stay the same. If you want a formula to always refer to the same cell no matter where you copy it, use a dollar sign before the part that should not change. =A$1+B1 will keep row 1 the same but change the column when you copy it across. =$A$1+$B$1 will never change at all.

You can edit a formula to add dollar signs before you copy it, or you can copy first and then edit the pasted formula. Paste Special with Formulas only is useful here because it lets you paste the formula without the formatting, so you can see exactly what you are working with.

Moving data instead of copying

If you want to move data rather than copy it, use Ctrl+X (or Cmd+X on Mac) instead of Ctrl+C. This cuts the data, removing it from the original location. Then paste it where you want it with Ctrl+V. The data disappears from the first location and appears in the second.

Cut and paste is useful when you are reorganizing a spreadsheet and do not want the same data in two places. Copy and paste is better when you need the data in both locations or when you are using data from one sheet to build something in another.

Common mistakes and how to avoid them

The most common mistake is copying a formula and forgetting that it will adjust automatically. If you copy =SUM(A1:A10) down to the next row, it becomes =SUM(A2:A11), which might not be what you wanted. Check your formulas after pasting by clicking on a pasted cell and looking at the formula bar at the top to see what it actually says.

Another mistake is pasting over data you meant to keep. Excel will not warn you before overwriting cells. If you paste in the wrong place, press Ctrl+Z when ready to undo. You can undo multiple times if you need to go back several steps.

Pasting formatting by accident is also common. If you copy a cell with a colored background and paste it into cells you wanted to keep plain, use Paste Special and choose Values to avoid bringing the formatting along.

Frequently Asked Questions

Can I copy data from another program and paste it into Excel?

Yes. Copy the data from the other program, click a cell in Excel, and paste. Excel will try to figure out where the columns and rows should go. If it does not look right, use Paste Special to see if a different paste option works better. Text from a website or document usually pastes as a single column, and you may need to use the Text to Columns feature to split it up.

What is the difference between copying a cell and copying a range?

A single cell copies just that one cell. A range copies multiple cells at once, keeping their layout. If you copy three cells in a row and paste them, they will paste as three cells in a row in the new location. The structure stays the same.

Why does my formula show as text instead of calculating?

This usually happens when you paste a formula into a cell that is formatted as text. Click the cell, go to the Home tab, click the Format Cells dropdown, and change the format to Number or General. Then press Enter to make the formula calculate. You may need to re-enter the formula if it still does not work.

Can I copy and paste between different Excel files?

Yes. Open both files, copy from one, switch to the other, and paste. If the files are on different sheets within the same workbook, you can copy from one sheet and paste into another the same way. Formulas that reference the first sheet will still work after you paste.

How do I paste without the dotted border around the copied cells?

Press Escape after pasting, or click anywhere else in the sheet. The dotted border shows that the cells are still in the clipboard and ready to paste again if you want. It disappears automatically after a few minutes or when you copy something else.