The basic copy and paste method

To copy and paste in Excel, select the cell or cells you want to copy, press Ctrl+C (or Cmd+C on Mac), click where you want to paste, and press Ctrl+V (or Cmd+V on Mac). That is the fastest way for most everyday work.

Start by clicking on a single cell. You will see a border appear around it — that means it is selected. If you need multiple cells, click the first one, then hold Shift and click the last cell you want. Excel will highlight all the cells in between. You can also click and drag across cells to select a range.

Once your cells are selected, press Ctrl+C. You will notice a dotted border (sometimes called "marching ants") appears around the cells you copied. This tells you the copy worked and Excel is holding those cells in memory, ready to paste.

Now click on the cell where you want the data to go. This is your starting point — if you copied three cells, Excel will paste them starting from wherever you click. Press Ctrl+V and the data appears.

Key Takeaways

  • Ctrl+C copies what you selected, and Ctrl+V pastes it into the cell you clicked on.
  • The dotted border around copied cells shows Excel is holding them in memory; press Escape to clear it if you change your mind.
  • Paste Special (Ctrl+Shift+V) lets you paste only values, formulas, or formatting instead of everything at once.
  • Copying a cell with a formula pastes the formula and adjusts the cell references automatically unless you lock them with dollar signs.

Selecting different ranges of cells

Sometimes you need to copy cells that are not next to each other. Click the first cell, hold Ctrl (or Cmd on Mac), and click each additional cell or range you want. Excel will select all of them even though they are separated. When you copy and paste, all the selected cells paste in their same pattern.

If you need to copy an entire row or column, click the row number on the left side or the column letter at the top. The whole row or column highlights, and you can copy and paste it the same way. This is useful when you want to duplicate a header row or move all the data in one column to another location.

You can also select a named range if your spreadsheet uses them. Named ranges are groups of cells you have given a specific name to (like "Sales_Q1" or "Employee_List"). Click the Name Box on the left side of the formula bar, type the range name, and press Enter. Excel selects that entire range so you can copy it.

Understanding what happens when you paste formulas

When you copy a cell that contains a formula, Excel does not paste the exact same formula — it adjusts the cell references to match the new location. If you copy a cell with the formula =A1+B1 and paste it one row down, it becomes =A2+B2. This is called a relative reference and it is usually what you want.

Sometimes you need the formula to stay exactly the same no matter where you paste it. To do this, use a absolute reference by adding dollar signs. Change =A1+B1 to =$A$1+$B$1, and when you copy and paste, the formula will always point to cells A1 and B1. You can also lock just the row (=$A1) or just the column (=A$1) if you only want part of the reference to stay fixed.

If you copy a formula and paste it somewhere, but you only want the result (the number it calculated), not the formula itself, use Paste Special instead. This is covered in the next section.

Using Paste Special to control what gets pasted

Paste Special gives you control over exactly what pastes. Press Ctrl+Shift+V (or Cmd+Shift+V on Mac) after you have copied something. A dialog box opens with several options.

The most common uses are: paste only the values (the numbers or text, not the formula), paste only the formatting (colors, fonts, borders), or paste only the formulas. If you copied a cell with a formula that calculated to 500, and you paste only values, the 500 appears but there is no formula behind it. This is useful when you want to lock in a calculation or move data to a place where you do not want formulas to update.

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 Excel flips the orientation. This saves time when you have data arranged one way but need it arranged another way.

Copying and pasting between different Excel files

You can copy from one Excel file and paste into another the same way you copy within a file. Open both files (or both windows of the same file), copy from the first, click into the second, and paste. The data moves across files without any extra steps.

If you copy a cell with a formula that refers to other cells in the original file, those references may break in the new file. Excel tries to adjust them, but if the other file does not have the same structure, you might see #REF! errors. In this case, use Paste Special and choose "Values" instead of pasting the formula.

When you copy from Excel and paste into a different program (like Word or Google Sheets), the formatting sometimes changes. If this happens, use Paste Special in the other program and choose "Unformatted Text" or the equivalent option. This pastes just the data without Excel's formatting.

Fixing common copy and paste problems

If you copy something but it will not paste, the most common reason is that you forgot to press Ctrl+C. You might have selected the cells but not actually copied them. Look for the dotted border around the cells — if it is not there, press Ctrl+C again.

If you see #REF! errors after pasting, it means the formula is trying to reference cells that do not exist in the new location. Use Ctrl+Z to undo, then use Paste Special and choose "Values" instead. This pastes only the numbers, not the broken formula.

If the pasted data looks wrong — wrong size, wrong position, or overlapping other data — press Ctrl+Z to undo and try again. Make sure you clicked on the correct starting cell before pasting. If you need to paste into a specific spot, click that exact cell first.

If you copy a large range and Excel seems slow or frozen, it is usually still working. Wait a few seconds before pressing Ctrl+V. Very large spreadsheets can take a moment to process the copy command.

Keyboard shortcuts that save time

Beyond Ctrl+C and Ctrl+V, a few other shortcuts make copying faster. Press Ctrl+D to fill down — copy the cell above and paste it into all selected cells below. This is faster than copy-paste when you want to repeat a value or formula down a column.

Press Ctrl+R to fill right — copy the cell to the left and paste it into all selected cells to the right. This works the same way as fill down but moves across columns instead.

If you want to copy a cell and paste it into many places, try the clipboard. Press Ctrl+C to copy, then press Ctrl+Alt+V (Windows) or Ctrl+Option+V (Mac) to open Paste Special. You can paste the same copied content multiple times without copying again.

Frequently Asked Questions

Can I copy and paste between Excel and Google Sheets?

Yes. Open both in your browser, copy from one, and paste into the other. Formulas usually transfer, but formatting sometimes changes. If the data looks wrong, use Paste Special in Google Sheets and choose "Paste values only" to paste just the numbers without formatting.

What does the dotted border around copied cells mean?

The dotted border (marching ants) shows that Excel has copied those cells and is holding them in memory. It stays there until you press Escape or copy something else. You can paste the same cells multiple times while the border is visible.

Why do my formulas show #REF! after I paste?

The formula is trying to reference cells that do not exist in the new location. Undo with Ctrl+Z, then use Paste Special (Ctrl+Shift+V) and choose "Values" to paste only the numbers instead of the formula.

Can I copy a formula but keep the cell references the same?

Yes. Edit the formula and add dollar signs before the column letter and row number: =$A$1 instead of =A1. The dollar signs lock the reference so it does not change when you paste.

How do I copy only the formatting, not the data?

Use Paste Special (Ctrl+Shift+V) and choose "Formatting" from the dialog. This copies the colors, fonts, borders, and number formats without changing the data in the cells you paste into.