Excel Paste Keyboard Shortcuts: Copy, Paste Special & More

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, press Ctrl+V to paste the copied or cut cells; use Ctrl+C to copy and Ctrl+X to cut first. For a controlled paste—such as values only—press Ctrl+Alt+V to open Paste Special, choose an option such as Values, then press Enter. On a Mac, the everyday paste shortcut is Command+V.

The essential Excel paste shortcuts

Excel’s standard shortcuts use the operating system’s familiar copy, cut, and paste keys. Select a cell or range, copy or cut it, select the destination, and paste. These commands work within a worksheet and, in many cases, between workbooks. The main Windows shortcuts are:

  • Ctrl+C: Copy the selected cell, range, or object without removing it from its original location.
  • Ctrl+X: Cut the selection so it can be moved elsewhere.
  • Ctrl+V: Paste the clipboard contents into the selected destination.
  • Ctrl+Alt+V: Open the Paste Special dialog, where you can choose what to transfer.

After copying a cell, Excel usually marks its outline with a moving dashed border. That border indicates the copied selection is still available to paste. Press Esc to cancel the copy outline when you are done. Cutting has a similar moving border, but the source content is intended to move rather than be duplicated.

For example, to copy a value from B2 to D2, select B2, press Ctrl+C, select D2, and press Ctrl+V. To move it instead, use Ctrl+X before selecting D2. A paste normally starts at the active destination cell, so selecting one cell is enough when pasting a rectangular range.

How Paste Special works

A regular paste brings over more than the visible text in a cell. Depending on the source, it can transfer formulas, number formats, cell formatting, and other cell properties. Paste Special lets you choose a subset or apply a particular operation rather than accepting the full default paste.

On Windows, copy or cut the source, select the destination, and press Ctrl+Alt+V. In the dialog, select the needed option and confirm. In the standard Paste Special dialog, the keyboard letters include V for Values, F for Formulas, and T for Formats; press the letter and then Enter. You can also choose an option with the mouse. Excel’s dialog offers additional choices, and the available options depend on what was copied.

On Mac, use Control+Command+V to open Paste Special in Excel, or use the ribbon: Home > Paste > Paste Special. The exact dialog presentation can differ from Windows. In Excel for the web, use the available Home > Paste options; desktop keyboard combinations and dialog behavior may not be identical in a browser.

Paste Special is particularly useful when a cell’s displayed value is correct but its underlying formula or appearance is not wanted. If a cell calculates a total, pasting Values places the current result in the destination instead of copying the formula. If the destination should adopt the source’s appearance without changing its contents, choose Formats.

Common paste choices and when to use them

The right paste option depends on what should change in the destination. A few typical cases make the distinction clear:

  • Values: Use this to retain the calculated result or text but not the source formula. It is helpful when sharing a fixed snapshot or preventing a copied formula from adjusting to a new location.
  • Formulas: Use this when the destination should contain the source formula. Relative references can adjust as the formula moves, so check the result if the formula points to nearby cells.
  • Formats: Use this to copy visual styling—such as number formats, fills, borders, and fonts—without replacing the destination’s value.
  • Column widths: Use this when reproducing a layout and the destination columns should match the copied columns. This option is available through Paste Special rather than ordinary paste.
  • Transpose: Use this to switch rows and columns when pasting a copied rectangular range. Select Transpose in Paste Special; it is a paste choice, not a separate Ctrl+V-style shortcut.
  • Skip blanks: When available for the copied range, this option leaves destination cells unchanged where the source cells are blank. It can be useful when updating only populated entries in an existing block.

Paste Special also includes mathematical operations for applying copied values to destination values, such as adding or multiplying. These options change the destination cells, so inspect the selected range carefully before confirming. If a result is not what you wanted, use Ctrl+Z immediately to undo the paste, provided you have not performed an action that clears Excel’s undo history.

Pasting a range, formula, or value

When you paste a rectangular block, select only the top-left destination cell unless you have a specific reason to select a larger destination. Excel fills the necessary cells from that starting point. If the source block is three columns wide and four rows tall, Excel attempts to paste a block of the same dimensions. A destination that overlaps protected or occupied cells can produce an error or overwrite existing content, so check the target area first.

Pasting formulas deserves a closer look. Suppose C2 contains a formula referring to A2 and B2. Copying C2 to C3 usually adjusts relative references to refer to A3 and B3. This behavior is often useful when filling a calculation down a table, but it can be surprising if you expected the formula to keep pointing at the original cells. References marked with dollar signs, such as $A$2, are absolute and do not shift in the same way.

If you only need the current calculated answer, use Paste Special > Values rather than a standard paste. For instance, a report may show 125 in a cell even though the cell contains a formula. Pasting the value creates a fixed 125 at the destination; pasting the formula copies the calculation, which may produce a different result when its references adjust.

Be cautious when copying a range that includes hidden rows or columns, filtered data, or merged cells. The selection may not behave like a simple uninterrupted rectangle, and the paste result can be confusing. For filtered lists, check which rows are selected before copying, and verify the pasted rows before deleting or replacing the source.

Related shortcuts: fill down and fill right

Some tasks that look like pasting are better handled with Excel’s fill shortcuts. On Windows, Ctrl+D fills down from the top cell of a selected range, while Ctrl+R fills right from the leftmost cell. These are not general clipboard paste commands: they copy the contents and formatting from the starting edge across the selected range.

For example, if A2 contains a formula and you want the same calculation pattern in A3 through A10, select A2:A10 and press Ctrl+D. Excel fills the lower cells using the first cell as the source, adjusting relative references as appropriate. If you have already copied a cell and want to paste it to a non-adjacent place, Ctrl+V is the more direct choice.

Filling can be faster than repeatedly copying and pasting into adjacent cells, but it is important to select the range in the correct direction. Ctrl+D uses the top row of the selection; Ctrl+R uses the left column. If the source cell is not at that edge, the result may not match your intention.

Windows, Mac, and Excel for the web

On Windows, use Ctrl+C, Ctrl+X, and Ctrl+V. On Mac, the standard equivalents use the Command key: Command+C, Command+X, and Command+V. The modifier-key difference matters because pressing Control instead of Command for ordinary copy and paste on a Mac will not usually perform the expected Excel command.

Paste Special is another place where platform differences matter. Windows uses Ctrl+Alt+V to open the dialog; Excel for Mac supports Control+Command+V, and the ribbon route is a useful alternative when a shortcut is unfamiliar. In Excel for the web, browser permissions or keyboard handling can affect clipboard actions. If a shortcut does not work, try the Home tab’s Paste controls and follow any browser prompt to allow clipboard access.

Excel for the web may also handle a copied selection differently from the desktop app when content comes from another program or when the browser restricts clipboard access. If a paste loses formatting or does not include the expected cells, try copying within Excel, use the ribbon paste options, or open the workbook in the desktop app if you need a Paste Special choice that is unavailable in the browser.

Common paste problems and fixes

If Ctrl+V appears to do nothing, first check that a cell or object was actually copied and that the intended worksheet is active. A copy outline can be a useful clue, but it may disappear if you press Esc, copy something else, or perform an action that replaces the clipboard contents. Copy the source again and try a simple destination cell.

  • The pasted result has the wrong formatting: Undo with Ctrl+Z, then use Paste Special > Values or Formulas, depending on what you want to preserve.
  • A formula gives a different answer: Check whether relative references shifted after copying. Use absolute references in the formula where fixed references are needed, or paste the result as a value.
  • Excel reports that the copy and paste areas are different: The source and destination selections may have incompatible shapes. Try selecting just one starting cell, or make the destination range match the copied range.
  • You cannot paste into the cells: Check whether the worksheet is protected, the destination is part of a merged range, or the workbook is in a state that prevents editing.
  • Content from another application pastes strangely: The clipboard may contain text or formatting in a form Excel interprets differently. Try Paste Special or paste into a plain-text editor first if you need to inspect the copied text.

When a paste overwrites data, Ctrl+Z is usually the quickest recovery. Avoid making several more edits before undoing, since that may undo unrelated work too. For important sheets, save a copy before large-scale replacement or a multi-cell Paste Special operation.

Choosing the right paste method

Use regular Ctrl+V when you want a straightforward copy of a cell or range and are comfortable bringing across its normal cell content and associated properties. Use Paste Special when you need to control what is transferred. Use Fill Down or Fill Right for extending a pattern from the edge of a selected range, rather than for moving a selection to an unrelated location.

A practical sequence for a report might be: copy a formula-driven summary, paste values into a separate sheet to freeze the results, then use Formats if the report needs consistent appearance. Another common sequence is copying a template row, pasting it into a new part of a worksheet, and then checking formulas and references before entering new data. These habits reduce accidental overwrites and make the pasted output easier to verify.

Before using any paste command on a large selection, confirm three things: what is on the clipboard, where the paste will begin, and whether you want formulas, displayed values, or formatting. This quick check is more reliable than trying to repair an unintended paste afterward.

Frequently Asked Questions

What is the keyboard shortcut to paste in Excel?
On Windows, press Ctrl+V. On a Mac, press Command+V. Select the destination cell first; when pasting a range, Excel starts the pasted block at that cell.

How do I paste values only in Excel?
On Windows, copy the source, select the destination, press Ctrl+Alt+V, choose Values with V, and press Enter. On Mac, open Paste Special with Control+Command+V or use Home > Paste > Paste Special, then choose Values.

What shortcut opens Paste Special?
In Excel for Microsoft 365 on Windows, Ctrl+Alt+V opens the Paste Special dialog. In Excel for Mac, Control+Command+V is the corresponding shortcut. You can use the ribbon’s Paste menu if you prefer not to use a key combination.

How do I paste without changing the original cell?
Use Ctrl+C on Windows or Command+C on Mac, not Cut. Copying leaves the source in place; cutting is intended to move the selection. Then choose the destination and paste.

Why does my pasted formula show a different result?
Excel adjusts relative cell references when a formula is copied to another location. Review the formula’s references, use absolute references where they should stay fixed, or paste values if you need the original calculated result rather than a relocated formula.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.