The three ways to copy in Excel, and when to use each one

Copying in Excel means three different things depending on what you need: copying the content of a cell so you can paste it elsewhere, copying an entire sheet so you have a duplicate to work from, or copying a formula down a column so it adjusts automatically for each row. The method you use depends on whether you want the copy to stay linked to the original, whether you want formulas to recalculate, and whether you're moving data or keeping both versions.

The most common copy is the cell copy: you select what you want, press Ctrl+C (or Cmd+C on Mac), click where you want it to go, and press Ctrl+V. That pastes the content as-is. But Excel also lets you paste only the values, only the formatting, or only the formula — which matters when you copy a formula from one place to another and need it to adjust for the new row or column.

Key Takeaways

  • Ctrl+C copies a cell or range; Ctrl+V pastes it, and formulas automatically adjust to the new row or column location.
  • Right-click and choose Paste Special to paste only values, only formatting, or only formulas when you don't want everything.
  • To copy a formula down a column, select the cell with the formula, then drag the small square at the bottom-right corner down as far as you need.
  • To duplicate an entire sheet, right-click the sheet tab at the bottom and choose Move or Copy, then select where the copy should go.
  • Copying a sheet creates a completely separate copy — changes to one sheet do not affect the other.

Copying a single cell or a range of cells

Select the cell or cells you want to copy. If it's a single cell, click it once. If it's a range — say, cells A1 through D5 — click the first cell, hold Shift, and click the last cell. You can also click and drag to select a rectangle of cells.

Press Ctrl+C on Windows or Cmd+C on Mac. You'll see a dotted border (called a marching ants border) appear around the cells you selected. This tells you the copy is ready. Click the cell where you want the copy to start, then press Ctrl+V. The content pastes, and if you copied a formula, it adjusts automatically to the new location. If you copied a cell in row 2 that says =A2+B2, and you paste it into row 3, it becomes =A3+B3.

Press Escape or click elsewhere to clear the dotted border and finish the copy.

Using Paste Special to control what gets copied

Sometimes you want only part of what's in a cell. You might copy a formula but want to paste only the result it produces, not the formula itself. Or you might copy formatting from one cell and want to paste it onto different data. That's what Paste Special does.

After you copy (Ctrl+C), right-click the cell where you want to paste and choose Paste Special. A dialog box opens with options. The most useful ones are: Values (pastes only the numbers or text, not the formula), Formats (pastes only the colors, fonts, and borders), and Formulas (pastes only the formula, not the formatting). You can also choose to transpose, which flips rows and columns — useful if you copied data in a row and want to paste it as a column instead.

On Windows, you can also press Ctrl+Shift+V to open Paste Special directly without right-clicking. On Mac, it's Cmd+Ctrl+V.

Copying a formula down a column or across a row

When you have a formula in one cell and need it to repeat in the cells below (or to the right), you don't have to copy and paste each one individually. Select the cell with the formula. Look at the bottom-right corner of the cell — you'll see a small square. Click and hold that square, then drag down (or to the right) as far as you need. As you drag, Excel shows you how many cells you're filling. Release the mouse, and the formula copies down, adjusting the row numbers automatically.

If you have a lot of rows to fill, dragging can be tedious. Instead, select the cell with the formula, copy it (Ctrl+C), then select the entire range where you want it to go and paste (Ctrl+V). Excel fills the whole range at once and adjusts each formula for its row.

You can also double-click that small square at the bottom-right corner, and Excel will automatically fill down to the last row that has data in the column to the left. This is fast if your data is already filled in and you just need the formula to match.

Duplicating an entire sheet

To copy a whole sheet — all the data, formulas, formatting, and everything else on it — right-click the sheet tab at the bottom of the screen. The sheet tabs are the labeled buttons that say "Sheet1", "Sheet2", and so on. A menu appears with options including Move or Copy. Click that option.

A dialog box opens asking where you want the copy to go. You can choose to place it before or after any existing sheet. Check the box that says "Create a copy" (if it's not already checked), then click OK. Excel creates a new sheet with the same name plus a number — so "Sheet1" becomes "Sheet1 (2)". You can rename it by right-clicking the tab again and choosing Rename.

The copied sheet is completely independent. If you change data on the original sheet, the copy does not change. If you delete the original, the copy stays. This is useful when you want to keep a version of your work before you make big changes, or when you want to create a template sheet and duplicate it for different months or projects.

Moving vs. copying: the difference

Copying leaves the original in place and creates a second version. Moving removes the original and puts it somewhere else. When you cut (Ctrl+X) instead of copy (Ctrl+C), you're moving — the dotted border appears, but when you paste, the original is gone.

For sheets, the Move or Copy dialog lets you choose which one you want. If you uncheck "Create a copy", you're moving the sheet instead. The sheet tab moves to the new location, but all the data stays the same. Use this when you want to reorganize the order of your sheets or move a sheet to a different file.

Common mistakes and how to avoid them

The most common mistake is copying a formula and pasting it somewhere you didn't mean to, then not realizing the formula adjusted. Always check the formula bar (the long box at the top that shows what's in the selected cell) after you paste a formula to make sure it adjusted the way you wanted. If it didn't, press Ctrl+Z to undo and try again with Paste Special, pasting only values if you need the numbers to stay the same.

Another mistake is copying a sheet and then editing both versions without realizing they're separate. If you duplicate a sheet to make a backup, rename it right away so you know which is which — call it "Original" or "Backup" or "Before Changes". That way you won't accidentally edit the wrong one.

If you copy a large range and the paste doesn't work, check that the destination has enough empty space. Excel won't paste over data unless you tell it to. If you need to paste over existing data, right-click and choose Paste Special, then choose an option that overwrites what's there.

Frequently Asked Questions

What's the difference between copying a cell and copying a formula?

When you copy a cell that contains a formula, you're copying the formula itself, not just the result. When you paste it, the formula adjusts to the new location. If you want only the result (the number the formula produces), use Paste Special and choose Values.

Can I copy a formula from one sheet to another?

Yes. Copy the cell with the formula (Ctrl+C), go to the other sheet by clicking its tab, click the cell where you want it, and paste (Ctrl+V). The formula adjusts to the new location. If the formula refers to cells on the original sheet, those references stay the same — they don't change to the new sheet.

If I copy a sheet, do changes to one affect the other?

No. When you copy a sheet, you create a completely separate sheet. Changes to one sheet do not appear on the other. They're independent copies, like two separate files.

How do I copy only the formatting from one cell to another?

Copy the cell with the formatting you want (Ctrl+C), click the cell you want to format, right-click, choose Paste Special, and select Formats. This copies the colors, fonts, borders, and number formatting but leaves the data in the destination cell unchanged.

Can I undo a copy if I made a mistake?

Copying itself can't be undone because it doesn't change anything — you're just preparing to paste. But if you paste something you didn't mean to, press Ctrl+Z to undo the paste and restore what was there before.