How to Enable Paste Special in Excel

How-to basics · Updated November 20, 2026

To use Paste Special in Excel for Microsoft 365 on Windows, copy a cell or range, select the destination, then choose Home > Paste ▼ > Paste Special—or press Ctrl+Alt+V. Paste Special is normally available without turning on a separate setting; if it seems missing, check that Excel has copied cells and that you are not editing inside a cell.

What You’ll Need

  • A workbook open in desktop Excel, with the source data you want to copy.
  • A destination cell or range where you want to paste.
  • A copied selection in the Office clipboard. Copy the cells immediately before pasting if the clipboard contents may have changed.

You do not need administrator access, an add-in, or a special workbook setting for the standard Paste Special command. The available choices depend on what you copied: copying cells can offer formulas, values, formatting, and other options, while copied text or content from another program may show a different set.

Step-by-Step

  1. Select the source cells. Click the first cell and drag across the range, or select a cell and use Shift with the arrow keys to extend the selection. Copy the selection with Ctrl+C. You should see a moving outline around the copied cells. If you use Cut instead, some paste options may be unavailable or behave differently.
  2. Choose the destination. Click the cell where the pasted content should begin. For a multi-cell source, the destination range needs enough room for the copied rows and columns. You can usually select just the top-left destination cell; Excel fills the matching-sized area. Avoid double-clicking or clicking in the formula bar, because that puts Excel into edit mode rather than leaving a cell selected.
  3. Open the Paste Special choices. On the ribbon, select the Home tab. In the Clipboard group, open the arrow beside Paste and choose Paste Special. In some ribbon layouts, the Paste button is compact or the Clipboard group is collapsed; expand the group or click the Paste dropdown to see the options. The command is not a permanent on/off switch: it is a paste action shown when Excel has content available to paste.
  4. Use the keyboard shortcut if you prefer. With the source copied and a destination cell selected, press Ctrl+Alt+V on Windows. The Paste Special dialog opens when the copied content supports it. Use the arrow keys to move between choices, then press Enter, or click the option you want. If the shortcut does nothing, see the troubleshooting section rather than assuming the feature is disabled.
  5. Choose what to paste. Select the option that matches your goal. Values pastes displayed results without the original formulas. Formulas keeps the formulas but does not bring over the source cell formatting. Formats copies the appearance, such as number formats, fill, borders, and font styling, without replacing the destination values. The exact wording or availability can differ with the source content and Excel version.
  6. Check additional options before confirming. Depending on the dialog, you may be able to choose whether to paste comments or notes, validation, column widths, or other attributes. The Skip blanks option leaves destination cells unchanged where the copied source cells are blank. Transpose switches rows and columns. Under Operation, options such as Add or Multiply apply a calculation to the destination values; use these carefully and confirm that the selected source and destination ranges line up.
  7. Apply the paste and inspect the result. Select OK if the dialog is open. Check several destination cells, especially if you chose formulas, an operation, or Transpose. For example, after pasting values, click a cell and look at the formula bar: it should show the result as a constant rather than the original formula. If the result is wrong, undo immediately with Ctrl+Z and repeat with the correct option.

Quick alternative: After copying, right-click the destination and look for the paste icons or Paste Special submenu. The icons can paste common choices such as values or formatting without opening the full dialog. The ribbon dropdown and Ctrl+Alt+V are more dependable ways to reach the full set of options in desktop Excel.

Mac and web differences: In Excel for Mac, copy and select the destination as above, then use Home > Paste dropdown > Paste Special. The keyboard shortcut commonly used to open Paste Special is Control+Command+V; keyboard mappings can vary with macOS and keyboard settings, so the ribbon is a reliable fallback. Excel for the web has a more limited set of paste choices and may not show the same desktop dialog or every operation. Use Home > Paste or the destination’s context menu and choose an available option. If a choice you need is missing, open the workbook in the desktop app.

Common Mistakes

  • Looking for a global Enable setting. Paste Special is generally available automatically. Searching Excel Options for an on/off control can waste time; first copy a cell range and open the Paste dropdown.
  • Copying a cell while editing its contents. If the cursor is inside a cell or the formula bar, Ctrl+C may copy text rather than the cell. Press Esc to leave edit mode, select the cell itself, and copy again.
  • Choosing Values when you need formulas. Values pastes the current results, not the calculations that created them. If the destination should recalculate when inputs change, choose Formulas instead.
  • Choosing Formulas when you need a fixed result. Formulas may bring references that adjust or point to other cells. Choose Values when you want a snapshot that will not depend on the source calculation.
  • Confusing formatting with values. Formats copies how cells look, not the numbers or text they contain. If a date or currency appears incorrectly, check the number format; formatting alone will not convert the underlying content.
  • Using a destination range of the wrong size. A copied block may overwrite adjacent cells or fail to fit as expected. Select the intended top-left cell and verify that the matching destination area is clear before pasting.
  • Expecting every option for every source. Excel may show fewer Paste Special choices when you copied content from a browser, another application, or a format with limited clipboard data. Copy directly from the worksheet when possible.

Tips

  • Use the Paste dropdown for a visual choice. Hover over an icon if available to see its label or preview. This is useful when you remember what you want to paste but not the name of the dialog option.
  • Use the dialog when precision matters. The full Paste Special dialog makes it easier to distinguish values, formulas, formats, transpose, skip blanks, and operations. Read the selected option before confirming, particularly when working with a large range.
  • Try a small sample first. If you are unsure how relative references, blank cells, or an operation will behave, test on a spare area or a copy of the worksheet. This is especially helpful when source and destination ranges differ in size.
  • Remember that pasted formulas can change references. When formulas are copied to a new location, relative references normally adjust to the new position. If you need the same formula references, use absolute references in the formula or choose Values for a fixed result.
  • Use Undo as a safety net, not a substitute for checking. Ctrl+Z reverses a recent paste in desktop Excel. Review the destination right away; further edits can make it harder to identify which action you need to undo.
  • Keep the workbook in a normal worksheet state. If the sheet is protected or the destination cells are locked, Excel may prevent the paste or some changes. Check the Review tab and confirm you have permission to edit the destination.

Troubleshooting

Paste Special is greyed out or absent. Copy the source cells again with Ctrl+C, then click a normal worksheet cell and reopen Home > Paste. If the copied outline has disappeared, Excel may no longer have the selection available; repeat the copy. Also check that the destination is not in cell-edit mode. Press Esc once, click the destination cell, and try again.

Ctrl+Alt+V does not open the dialog. First confirm that you copied worksheet cells and selected a destination. Some laptop keyboards, remote desktop software, or other applications can intercept key combinations. Use Home > Paste dropdown > Paste Special instead. On a Mac, try Control+Command+V or use the ribbon path.

The dialog appears, but the option you want is missing. The clipboard may contain text or an object instead of a normal range of cells. Return to the source sheet, select the cells, press Ctrl+C, and try again. If the workbook is open in Excel for the web, switch to desktop Excel for a broader set of paste options.

The paste changes more than you expected. Press Ctrl+Z immediately. Repeat the action and select only the needed attribute: Values for results, Formulas for calculations, or Formats for appearance. If you chose an Operation, verify that both ranges contain the intended numbers and that the destination selection is correctly aligned before applying it again.

The command is hard to find on the ribbon. Maximize the Excel window, select Home, and look in the Clipboard group. A narrow window or simplified ribbon can hide group labels or show a compact Paste button. Open its dropdown, or use the shortcut, rather than assuming the command has been removed.

Excel reports a problem with the destination. Check for merged cells, protected cells, or a destination range that does not match the shape of the copied data. Try pasting into an empty, unmerged area on an unprotected worksheet. If that works, the original destination layout or protection is the obstacle.

Frequently Asked Questions

Do I need to enable Paste Special in Excel?
No separate setting is normally required in Excel for Microsoft 365 on Windows. Copy cells, select a destination, and use Home > Paste dropdown > Paste Special or Ctrl+Alt+V.

Can I add Paste Special permanently to the ribbon?
The Paste Special choices are normally reached through the Paste dropdown in the Home tab’s Clipboard group. The ribbon may look different when it is collapsed or simplified. Use the dropdown or shortcut for reliable access; available customization options can vary by Excel version and ribbon layout.

What is the difference between Paste Values and Paste Formulas?
Paste Values inserts the calculated results as fixed contents. Paste Formulas copies the calculations, which can continue to update and may adjust cell references for the new location.

Why does Paste Special work for one copied item but not another?
Excel offers choices based on the kind of content stored on the clipboard. A copied cell range usually provides worksheet-specific choices, while text or objects from another program may offer a smaller or different set.

Does Paste Special work in Excel for the web?
Excel for the web supports some paste choices, but its menus and capabilities are not identical to desktop Excel. Open the workbook in the desktop app if you need an option that the web version does not display.

How do I paste without changing the destination formatting?
Copy the source, select the destination, and choose Values or Formulas from Paste Special, depending on what you need to retain. Avoid a standard paste if it would also bring source formatting.

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.