The fastest way to copy cells in Excel

To copy a cell or group of cells in Excel, select what you want to copy, press Ctrl+C (Windows) or Command+C (Mac), then click where you want it to go and press Ctrl+V or Command+V. That moves the data from one place to another without changing the original.

You can copy a single cell, a row, a column, or any rectangular block of cells. Click the first cell you want, then hold Shift and click the last cell in the range you need. Everything in between gets selected. Then copy and paste as usual.

If you want to copy without removing the original, just paste — the copy command never deletes anything. The original stays where it was, and you now have a second copy in the new location.

Key Takeaways

  • Ctrl+C (or Command+C on Mac) copies; Ctrl+V (or Command+V) pastes, and the original data always stays in place.
  • Select a range by clicking the first cell, holding Shift, and clicking the last cell you want included.
  • Paste Special lets you paste only the numbers or only the formatting, leaving behind formulas or blank cells.
  • Cut (Ctrl+X) moves data instead of copying it, and the original disappears once you paste.
  • Copying a cell with a formula copies the formula itself, which automatically adjusts row and column references in the new location.

Copying a single cell versus a range

A single cell is the easiest: click it once, press Ctrl+C, click the destination, and press Ctrl+V. The cell and everything in it — text, numbers, formulas, formatting — moves to the new spot.

For a range (multiple cells at once), click the top-left cell of the area you want to copy. Hold Shift and click the bottom-right cell. The entire rectangle between those two corners turns blue or highlighted. Now press Ctrl+C, navigate to where you want it, and press Ctrl+V. The whole block pastes as a unit, keeping the same shape and size.

You can also click and drag to select a range instead of using Shift+click. Click the first cell, hold the mouse button down, and drag to the last cell you want. Release, then copy and paste.

What happens to formulas when you copy

When you copy a cell that contains a formula, Excel copies the formula itself, not just the result. If the original cell says =A1+B1 and you copy it to a new row, the formula automatically adjusts to =A2+B2 in the new location. This is called a relative reference, and it saves time when you need the same calculation repeated down a column.

Sometimes you do not want the formula to change. If you want the formula to always point to the same cells no matter where you paste it, you need an absolute reference. In the formula bar, change =A1+B1 to =$A$1+$B$1. The dollar signs lock those cells. Now when you copy and paste, the formula always refers back to A1 and B1, never adjusting.

You can also mix them: =$A1+B$1 locks the column A but lets the row number change, or locks the row but lets the column change. This matters most when you are copying formulas across many cells and need some references to stay fixed while others move.

Using Paste Special to paste only what you need

Sometimes you copy a cell but only want the number, not the formula behind it. Or you want the formatting (bold, color, borders) but not the data. That is where Paste Special comes in.

After you copy, right-click the destination cell and select Paste Special. A dialog box opens with options. Check Values to paste only the numbers or text, leaving formulas behind. Check Formats to paste only the colors, fonts, and borders. You can also paste Formulas alone, or Comments if the original cells have notes attached.

On Windows, you can also press Ctrl+Shift+V to open Paste Special directly. On Mac, it is Command+Shift+V. This is faster than right-clicking if you use it often.

The difference between copy and cut

Copy leaves the original data in place. Cut removes it. After you press Ctrl+X (cut), the original cell stays visible but gets a dashed border around it, showing it is marked for removal. When you paste, the data moves to the new location and the original cell becomes empty.

Use cut when you are reorganizing — moving a row of data from one place to another. Use copy when you need the same information in two places, like copying a total down to a summary sheet.

If you cut something and then change your mind, press Ctrl+Z to undo. The data goes back where it started. Once you paste a cut cell, the original is gone, so undo is your safety net if you made a mistake.

Copying between sheets and workbooks

You can copy from one sheet to another within the same workbook, or even between two different Excel files. The process is the same: copy the cells, switch to the other sheet or file, and paste.

If you have two Excel files open side by side, copy from one, click the other file's window, and paste. If the sheets are in the same workbook, copy, click the sheet tab at the bottom, and paste. The data carries over exactly as it was, including formulas and formatting.

One thing to watch: if you copy a formula that refers to cells in Sheet1, and you paste it into Sheet2, the formula still points back to Sheet1. If that is not what you want, use Paste Special and paste values only, then write new formulas in Sheet2 that refer to Sheet2 cells.

Avoiding common copy-paste mistakes

The most common mistake is copying a formula and forgetting that it adjusts automatically. You meant to copy =A1+B1 down a column, but you pasted it into a different area and now it is pointing to the wrong cells. Check the formula bar after you paste to make sure the references are what you expected.

Another mistake is copying a cell with a formula, pasting it as a value by accident, and losing the formula. If you need the formula to stay, use regular Ctrl+V paste, not Paste Special with Values checked. If you already pasted values and need the formula back, undo with Ctrl+Z.

Copying very large ranges (thousands of rows) can slow Excel down. If your spreadsheet is running slowly, try copying and pasting smaller chunks at a time, or close other programs to free up memory.

Frequently Asked Questions

Can I copy a cell and paste it multiple times?

Yes. After you copy with Ctrl+C, you can paste as many times as you want in different locations. The copy stays in your clipboard until you copy something else. Click each destination and press Ctrl+V, and the same data appears in every place you paste.

What if I copy a cell with a formula and the numbers change in the new location?

The formula adjusted its references automatically. If the original was =A1+B1 and you pasted it one row down, it became =A2+B2. If that is wrong, undo with Ctrl+Z, edit the formula to use absolute references (=$A$1+$B$1), and copy again.

How do I copy just the formatting without the data?

Copy the cell with Ctrl+C, right-click the destination, choose Paste Special, and check only Formats. The colors, fonts, borders, and number formatting copy over, but the cell stays empty. You can then type new data into it.

Can I undo a paste if I made a mistake?

Yes, press Ctrl+Z when ready after pasting. This undoes the paste and puts the data back where it was. You can undo multiple times to go back several steps if needed.

What happens if I copy a cell with a comment?

By default, comments do not copy. If you want the comment to copy too, use Paste Special and check Comments along with whatever else you need. Otherwise, only the cell content and formatting copy over.