Excel Paste Options: Find, Choose, and Use the Right One

To get Paste Options in Excel, copy a cell or range, select the destination, and paste with Ctrl+V; then click the small Paste Options button beside the pasted cells, or open Home > Paste to choose an option before pasting. These choices let you paste only values, formulas, formatting, or other parts of copied cells instead of carrying everything over.

The instructions below are for Excel for Microsoft 365 on Windows. You need to copy cells first: Paste Options are not a separate setting that stays open all the time, and the choices shown can vary with what you copied.

What You’ll Need

A workbook open in Excel, with the cells or range you want to copy.
A destination cell or range where you have permission to paste. If the workbook or sheet is protected, some paste actions may be blocked.
Optional: a clear idea of what should carry over, such as values only, formulas, formatting, or column widths.

Step-by-Step

Select the source cells. Click one cell, or drag across a range. To select a whole column or row, click its letter or number heading. If the source is a table, select the cells you actually want to copy rather than the whole sheet unless you intend to bring all of it across.
Copy the selection. Press Ctrl+C on Windows. You can also right-click the selection and choose Copy, or use Home > Copy. A moving dashed outline usually appears around the copied cells; this is a useful sign that Excel still has the copied range available.
Choose the destination. Click the upper-left cell where the pasted content should begin. If you copied a multi-cell range, make sure the destination has enough room and does not overlap data you need to keep. Excel fills the destination starting at that cell. You generally do not need to select a destination range of exactly the same size.
Paste normally to reveal the quick options. Press Ctrl+V, or right-click the destination and choose Paste. After the cells appear, look beside or just below the pasted range for a small clipboard button. Click it to open the Paste Options menu. The button can disappear when you click elsewhere, so use it before moving on if you want to change the paste behavior.
Choose the result you want. Point to an option to see its tooltip when available, then select it. Common choices include Keep Source Formatting, which brings the copied appearance; Match Destination Formatting, which adopts the destination’s look; Values, which pastes calculated results rather than formulas; Formulas, which pastes formulas without all the source formatting; and Transpose, which switches rows and columns. Depending on the copied content, you may also see options for formatting, links, or pictures. Not every option appears for every selection.
Use the Paste menu if the button is missing. Select the destination, then go to Home > Paste and open its drop-down arrow. Choose the relevant paste option before pasting. The menu usually shows icons; pause over an icon to read its tooltip rather than guessing from the picture. You can also right-click the destination and look under Paste Options in the context menu.
Open Paste Special for more control. Copy the source, select the destination, and press Ctrl+Alt+V on Windows. Alternatively, choose Home > Paste > Paste Special. In the dialog, choose a radio option such as Values, Formulas, or Formats, then select OK. The dialog can also offer choices such as Column widths, Transpose, Skip blanks, and Paste Link. These are useful when you need a particular result rather than a quick one-click paste.
Check the pasted cells. Click a pasted cell and look at the formula bar. If you chose Values, you should see the displayed result as a fixed value rather than the original formula. If you chose Formulas, confirm that references point to the intended cells; relative references may shift when a formula is pasted into a new location. If the result is wrong, press Ctrl+Z immediately and repeat the paste with a different option.

On a Mac, use Command+C and Command+V for copying and pasting. The Paste menu is available from the ribbon, and the Paste Special dialog can be opened with Control+Command+V in Excel for Mac; menu names and the options available can differ slightly from Windows. In Excel for the web, use the Home tab’s Paste menu or the right-click menu. The web version has a more limited set of paste choices in some situations, so if an option you need is unavailable, open the workbook in the desktop app.

Common Mistakes

Looking for Paste Options before copying. The quick options relate to copied content. If nothing has been copied, start by selecting the source cells and copying them.
Assuming Values means the same as normal Paste. Normal paste may bring formulas and formatting along. Values pastes the current results and removes the formulas from the pasted cells. This is helpful for freezing results, but it means those cells will not update when the original inputs change.
Choosing Formats when you meant Values. Formats changes how cells look, such as number formats, borders, or fills; it does not replace the destination’s contents with the source’s displayed numbers. For numbers that should no longer calculate, use Values.
Overwriting nearby data. Pasting a larger copied block can replace existing cells starting at the destination. Check the range first, and undo immediately if you paste over something important.
Expecting formulas to keep the same references. Excel adjusts relative references when formulas move. If a copied formula changes its referenced cells, check whether that is expected before filling a larger area.
Clicking away before using the small clipboard button. The button is a temporary shortcut. If it vanishes, copy the source again and use Home > Paste or Paste Special instead.

Tips

Use the menu tooltips. Paste icons can be similar, and their order may vary by Excel version or context. Hover over an icon to read its name before choosing it.
Use Paste Special to paste just one property. Choose Values to keep results, Formats to apply appearance, or Column widths to match sizing without replacing the cell contents. For a one-time calculation, the dialog’s Add, Subtract, Multiply, or Divide operation can apply the copied value to destination cells; check the selected range carefully before confirming.
Use Skip blanks with care. In Paste Special, Skip blanks prevents empty cells in the copied range from replacing existing destination contents. It does not remove blank cells from the copied block or shift other values into their place.
Use Transpose for a layout change. Copy a horizontal list, choose Transpose, and Excel pastes it vertically; a vertical list can be turned into a row. Check the destination space because the pasted dimensions are reversed.
Undo quickly if the preview is not right. Ctrl+Z on Windows, or Command+Z on Mac, reverses a recent paste. For important workbooks, save a copy before making a large or complex paste.

Troubleshooting

The Paste Options button does not appear: It may be hidden because the selection was not copied, you clicked elsewhere, or your Excel version does not show the button for that paste operation. Copy again, click the destination, and use Home > Paste. For specific choices, open Paste Special. You can also check Excel’s display settings: in Windows desktop Excel, go to File > Options > Advanced and look for the cut, copy, and paste options that control whether paste buttons are shown. Setting names can vary slightly between builds.

Paste is greyed out or nothing happens: Confirm that a cell range is copied and that the destination is a normal editable cell. Press Esc only if you want to cancel the copy; doing so clears the copied selection. A protected sheet, an active cell-editing cursor, or certain selections can prevent pasting. Press Enter or Esc to leave cell editing, select an editable destination, and try again. If copying from another application, recopy the source because the clipboard may no longer contain compatible content.

The pasted result looks different from the source: Try Keep Source Formatting or Formats if you want the copied appearance. If the destination has the preferred style, choose Match Destination Formatting. For dates, percentages, and currency, the number format affects how a value is displayed, so choose Values and Number Formats if that choice is available and you need both the result and its display format.

Formulas show unexpected results or errors: Check the formula bar and inspect the cell references. Pasting can adjust relative references, while absolute references marked with dollar signs remain fixed. If you only need the current result, undo and paste Values. If you need a live formula, correct its references or copy it to a location where the relative shifts are appropriate.

An option is missing from Excel for the web or Mac: The menus and supported paste types are not identical across platforms. Try the ribbon’s Paste drop-down or Paste Special dialog. If a required operation is not offered in the web app, open the workbook in Excel for Microsoft 365 desktop on Windows or Mac and use its Paste Special choices.

Frequently Asked Questions

Where are Paste Options in Excel?

After you copy and paste cells, look for the small clipboard button next to the pasted range. You can also find choices under Home > Paste or in the right-click menu. The button is temporary; the ribbon menu is the reliable alternative.

How do I paste values only?

Copy the cells, select the destination, and choose Values from the Paste Options button or Home > Paste. You can also press Ctrl+Alt+V on Windows, select Values in Paste Special, and choose OK. This pastes results without the original formulas.

Can I make Paste Options appear every time?

The button appears only for paste actions where Excel provides it, and it may be hidden by a setting. In Windows desktop Excel, check File > Options > Advanced for the cut, copy, and paste display options. Even when the button is not shown, the Home > Paste menu and Paste Special are available alternatives.

Why does Excel paste formulas instead of numbers?

Normal Paste generally carries formulas when the source cells contain them. Choose Values to paste their current calculated results instead. The pasted values will not recalculate if the original formula inputs change.

How do I paste without changing the destination formatting?

Choose Formulas or Values from Paste Special, depending on whether you want formulas or fixed results. These choices avoid bringing over the source formatting. If available, Match Destination Formatting is another quick option for using the destination’s appearance.

Can I paste a column as a row?

Yes. Copy the column, select the destination’s upper-left cell, and choose Transpose from Paste Options or the Paste Special dialog. The reverse works for turning a row into a column. Make sure the destination has enough open cells in the new orientation.

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.