The basic copy and paste steps

Copy and paste in Excel works the same way as in most programs: select the cells you want, copy them, click where you want them to go, and paste. The quickest method uses keyboard shortcuts — Ctrl+C to copy on Windows or Command+C on Mac, then Ctrl+V or Command+V to paste. You can also right-click the selected cells and choose Copy from the menu, then right-click again at the destination and choose Paste.

The cell or range you copy stays marked with a moving dotted border (called the "marching ants") until you press Escape or copy something else. This border shows you what will paste if you press the paste shortcut. You can paste the same copied cells multiple times without copying again — just click a new location and paste.

Excel pastes everything by default: the values, the formulas, the formatting, and the borders. If you only want some of these, use Paste Special instead, which gives you control over what actually goes into the new cells.

Key Takeaways

  • Copy cells with Ctrl+C (Windows) or Command+C (Mac), then move to a new location and paste with Ctrl+V or Command+V.
  • The dotted border around copied cells shows what will paste; press Escape to clear it or copy something else to replace it.
  • Paste Special lets you paste only values, only formatting, only formulas, or any combination you choose.
  • When you paste over existing cells, Excel replaces the old content entirely unless you use Insert Cut Cells instead of regular paste.

Selecting cells before you copy

You must select the cells you want before copying. Click a single cell to select just that one, or click and drag to select a range. To select a rectangular block, click the top-left cell, hold Shift, and click the bottom-right cell. To select non-adjacent cells (cells that are not next to each other), click the first cell, then hold Ctrl (Windows) or Command (Mac) and click each additional cell or range you want.

You can also select an entire row by clicking the row number on the left, or an entire column by clicking the column letter at the top. If you want to select all cells in the sheet, press Ctrl+A (Windows) or Command+A (Mac), or click the box in the top-left corner where the row numbers and column letters meet.

Using Paste Special for more control

Paste Special opens a dialog box with options for what to paste. After copying, press Ctrl+Shift+V (Windows) or Command+Shift+V (Mac) to open it. You can then choose to paste only values (the numbers or text, without formulas), only formatting (colors, fonts, borders), only formulas, or combinations of these.

Paste Special is useful when you copy a cell with a formula and want to paste just the result into another sheet, or when you want to copy formatting from one cell to many others without changing their content. The dialog also has an "Operations" section that can add, subtract, multiply, or divide the pasted values by what is already in those cells — useful for adjusting a range of numbers all at once.

Copying and pasting between sheets

You can copy cells from one sheet and paste them into another sheet in the same workbook, or into a sheet in a different workbook entirely. The process is the same: copy from the first sheet, switch to the second sheet (by clicking its tab at the bottom), click the cell where you want to paste, and paste.

If you copy a formula from one sheet to another, Excel updates the cell references automatically. For example, if you copy a formula that refers to cell A1 in Sheet1, and paste it into Sheet2, the formula will refer to A1 in Sheet2 instead. If you want the formula to keep referring to Sheet1, you need to use absolute references (write $A$1 instead of A1) before copying.

What happens when you paste over existing cells

When you paste into cells that already have content, Excel replaces that content completely. There is no undo prompt — the old data is gone as soon as you paste. If you realize you made a mistake immediately, press Ctrl+Z (Windows) or Command+Z (Mac) to undo the paste and restore what was there.

If you want to insert the copied cells without replacing what is already there, use Insert Cut Cells instead. After copying, right-click the destination and choose "Insert Cut Cells" (or "Insert Copied Cells" in some versions). This shifts the existing cells to the right or down to make room for what you are pasting.

Copying formulas versus copying values

When you copy a cell with a formula, pasting it normally will paste the formula, and Excel adjusts the cell references for the new location. If the original cell is A1+B1 and you paste it one row down, the new cell becomes A2+B2. This is usually what you want when you are building a spreadsheet with repeated calculations.

If you want to paste only the result (the number that the formula calculated), use Paste Special and choose "Values" only. This is useful when you want to lock in a calculation and prevent it from changing if the original data changes, or when you are copying to a different sheet and do not want the formula to recalculate based on new cell references.

Keyboard shortcuts and menu alternatives

The fastest way to copy and paste is with keyboard shortcuts: Ctrl+C and Ctrl+V on Windows, Command+C and Command+V on Mac. Ctrl+X (or Command+X) cuts instead of copying — the cells are removed from their original location and pasted into the new one. Paste Special is Ctrl+Shift+V or Command+Shift+V.

If you prefer menus, go to the Home tab in the ribbon, find the Clipboard group, and click Copy or Paste. The Paste button has a small arrow next to it that opens a menu with Paste Special and other paste options. Right-clicking the cells also brings up a context menu with Copy, Cut, and Paste options.

Frequently Asked Questions

Can I copy a cell and paste it into multiple places at once?

No, but you can paste the same copied cells into as many locations as you want by clicking each location and pasting. The copied cells stay in the clipboard until you copy something else or press Escape, so you can paste repeatedly without re-copying.

What is the difference between copy and cut?

Copy leaves the original cells in place and duplicates them in the new location. Cut removes the original cells and moves them to the new location. Use Ctrl+X to cut, or right-click and choose Cut. The dotted border appears around cut cells just as it does around copied cells.

Why did my formula change when I pasted it?

Excel automatically adjusts cell references when you paste a formula to a new location. If you want the formula to refer to the same cells in the original location, use absolute references by adding dollar signs: $A$1 instead of A1. Then the reference stays the same no matter where you paste.

How do I paste only the formatting without changing the numbers?

Copy the cell with the formatting you want, then use Paste Special (Ctrl+Shift+V or Command+Shift+V) and choose "Formatting" only. This copies the colors, fonts, borders, and number formats without changing the actual values in the cells.

Can I undo a paste if I made a mistake?

Yes, press Ctrl+Z (Windows) or Command+Z (Mac) immediately after pasting to undo it. You can undo multiple times to go back several steps. If you wait too long or perform other actions, the undo history may not go back far enough.