Excel Paste Special: Copy Values, Formulas, and More

Formulas & functions · Updated November 20, 2026

To use Paste Special in Excel for Microsoft 365 on Windows, copy the source cells, select the destination, then choose Home > Paste > Paste Special and select what to transfer. You can paste values without formulas, copy only formatting, transpose rows and columns, or apply a calculation to the destination. This is useful when a normal paste would bring along unwanted content or change the layout.

What You’ll Need

  • An Excel workbook with the cells you want to copy and a destination range. Save a copy first if you are about to replace important data.
  • For the full set of Paste Special options, use the desktop version of Excel. Excel for the web offers a more limited set of paste choices, and the available options can depend on your browser and clipboard.
  • Know what you want to preserve: results, formulas, formatting, validation, column widths, or some combination. Choosing the right option prevents accidental changes.

Step-by-Step

  1. Select and copy the source. Click a cell or drag across the range you want to copy. Press Ctrl+C on Windows. A moving dashed outline usually marks the copied cells. Copy rather than cut: Paste Special is designed to paste copied content, while cutting moves the original cells.
  2. Select the destination. Click the top-left cell where the pasted content should begin. If you copied a multi-cell range, Excel places it starting at that cell and fills the matching area. Check that the destination will not overwrite data you need. To paste into a range of a different size, select the starting cell and let Excel determine the pasted footprint, or select a compatible destination range.
  3. Open Paste Special. On the ribbon, choose Home > Paste > Paste Special. The Paste command is in the Clipboard group. You can also press Ctrl+Alt+V on Windows after copying and selecting the destination to open the Paste Special dialog. If you do not see the command, click the arrow beneath Paste rather than the main Paste button.
  4. Choose what to paste. In the dialog, select an option under Paste. Choose Values to paste the displayed results without the formulas that produced them; choose Formulas to transfer formulas without the source formatting; choose Formats to transfer appearance only. Other useful choices include Comments and Notes, Validation, Column widths, and options that combine formulas or values with number formats. The exact wording can vary slightly by Excel build.
  5. Set any extra options. Leave Operation set to None for a normal paste. Turn on Transpose to switch rows into columns or columns into rows. Turn on Skip blanks to prevent blank source cells from replacing existing destination contents. Use Paste Link only when you want pasted cells to refer back to the source rather than become independent copies. Not every combination of options is available in every version.
  6. Confirm the paste. Click OK. Inspect a few destination cells before continuing: click a pasted value and look at the formula bar, or check the number format and appearance. If the result is wrong, press Ctrl+Z immediately to undo, then repeat the paste with the appropriate option.
  7. Use Paste Values for fixed results. For example, if cells contain formulas that calculate totals and you need to send a static copy, copy those cells, select the destination, open Paste Special, choose Values, and click OK. The displayed results are pasted, but the formulas are not. If you need the existing number appearance as well, choose Values and Number Formats when it is offered.
  8. Use Paste Special to apply a calculation. To add, subtract, multiply, or divide destination numbers by copied numbers, copy the source range, select the destination range, open Paste Special, and choose the matching operation under Operation. For instance, copying a cell containing 10 and using Add on selected destination cells adds 10 to each corresponding cell. Confirm the source and destination sizes and values first; the operation changes destination data rather than merely placing a copy beside it.
  9. Transpose when the layout needs to turn. Copy a horizontal row, click the top-left destination cell, open Paste Special, select Transpose, and confirm. Excel lays the row out vertically. The same option turns a copied column into a row. Leave room for the new layout so it does not overwrite other data.

Mac and web differences: In Excel for Mac, copy and select the destination, then use Edit > Paste Special or the Paste Special choice on the Home tab. The common Mac shortcut is Control+Command+V; keyboard settings and Excel releases can affect shortcut behavior, so the menu is a reliable alternative. On Excel for the web, look under Home > Paste for the choices available in your browser. If you need operations such as adding during paste or the complete desktop dialog, open the workbook in the desktop app.

Common Mistakes

  • Choosing Values when formats matter. Values pastes the cell results, not the source’s full appearance. Currency symbols, date display, borders, and fills may not come across as expected. Use Values and Number Formats for results plus number formats, or paste formats separately when appropriate.
  • Choosing Formulas when you wanted fixed numbers. Formulas can recalculate and may adjust their cell references when pasted to a new location. If the recipient needs results that will not change, use Values instead.
  • Using a mismatched destination range. A copied block may not align with the selected destination, especially when applying arithmetic or transposing. Check the shape and size of both ranges before confirming.
  • Leaving an operation selected. If you choose Multiply, Add, or another operation, Excel applies it to the destination instead of doing an ordinary paste. Set Operation to None for a standard transfer.
  • Expecting blank source cells to preserve destination data automatically. Without Skip blanks, blanks in the copied range can replace existing destination contents. Enable Skip blanks when that is the intended behavior, and verify the outcome.
  • Pasting over data or merged cells. A paste can replace existing content, and merged cells can prevent a range from fitting. Undo right away if the layout or data changes unexpectedly, then choose a clear, unmerged destination.

Tips

  • Use the Paste menu preview. The Home tab’s Paste dropdown may show icons or labels for common choices such as Values, Formulas, and Transpose. Hover over an option when available to identify it before clicking.
  • Paste formats separately. If you need the destination’s existing values but want it to look like the source, copy the source, select the destination, then choose Paste Special > Formats. This avoids replacing the destination data.
  • Keep formulas and appearance distinct. Formulas and number formats is useful when you want the calculation and its display format, but not all other formatting such as fills or borders. Choose the option that matches what should change.
  • Use Skip blanks selectively. It is helpful when filling gaps in an existing table, but it does not mean that every kind of empty-looking cell will be treated as blank. A formula returning an empty string is still a formula-containing cell.
  • Check links before sharing. Paste Link creates references to the copied source cells. If you move, delete, or share the source workbook, those links may no longer behave as intended. Use Values for a standalone snapshot.
  • Remember that undo is your safety net. Ctrl+Z on Windows or Command+Z on Mac reverses a recent paste. Review the result before performing many additional edits, since undoing later may also reverse those intervening actions.

Troubleshooting

Paste Special is unavailable or greyed out. Copy the cells again with Ctrl+C, then select a normal destination cell and reopen the menu. If you pressed Esc after copying, the clipboard selection may have been canceled. A protected sheet, an active edit inside a cell, or an incompatible selection can also restrict paste choices. Press Enter or Esc to leave cell editing, check the sheet’s protection status, and try again.

The pasted formula gives a different result. Formulas may use relative references, which adjust to the new location. Select the pasted cell and inspect the formula bar. If you wanted the original calculated result, undo and paste Values. If you did want the formula but need some references to stay fixed, update the formula’s references or use absolute references in the source before copying.

The destination shows unexpected dates, decimals, or currency. The underlying value may be correct while its number format differs. Undo, then use Values and Number Formats if available, or paste the desired formatting separately. You can also select the destination and choose a suitable number format from Home > Number.

Transpose or arithmetic paste fails. Check whether the destination overlaps the copied range, contains merged cells, or has a shape that does not match the source. For an operation, make sure the copied cells contain the values you intend to use and that the destination cells are suitable for the calculation. Try a small test range first, then repeat on the full range after confirming the result.

The option is missing in Excel for the web. Browser and web-app clipboard permissions can limit available choices. Try the Home tab’s Paste dropdown, allow clipboard access if the browser asks, or open the file in Excel for Microsoft 365 on Windows or Mac for the desktop Paste Special dialog.

Frequently Asked Questions

How do I paste values only in Excel?
Copy the source cells, select the destination, and choose Home > Paste > Paste Special > Values. In desktop Excel for Windows, Ctrl+Alt+V opens the dialog. Some ribbon versions also provide a Values option directly in the Paste dropdown.

Does Paste Special copy formulas?
Yes. Choose Formulas to paste formulas without the source formatting. Relative references can change to match the new location. Choose Values instead if you want the formula results as fixed entries.

Can I paste only formatting?
Yes. Copy the formatted source cells, select the destination, and choose Paste Special > Formats. This transfers appearance without replacing the destination’s contents.

How can I switch rows and columns while pasting?
Copy the range, select the destination’s top-left cell, and use Paste Special with Transpose selected. Make sure the new orientation has enough clear space.

Can Paste Special add or multiply numbers?
Yes. Copy the values to use in the calculation, select the destination, and choose Add, Subtract, Multiply, or Divide under Operation in the Paste Special dialog. Test the action on a small range first because it changes the destination values.

Is Paste Special the same in Excel for Mac?
The core choices are similar, but menus and shortcuts differ. On Mac, use Edit > Paste Special or the Home tab; Control+Command+V is a common shortcut. If it does not open the dialog, use the menu path for your Excel release.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.