Paste Values Not Working in Excel? Causes and Fixes

If Paste Values is not working in Excel, copy the source cells again, select the destination, then choose Home > Paste > Values. In Excel for Microsoft 365 on Windows, you can also press Ctrl+Alt+V, press V, and press Enter; if that fails, check the selected ranges, sheet protection, and whether the copied cells contain the results you expect.

What Paste Values does—and what it leaves out

Ordinary paste transfers a cell’s contents and often its formatting, formulas, comments, and other properties. Paste Values instead transfers the evaluated result of a formula, or the existing constant in a cell, without replacing the destination’s formatting. This is useful when you want a number or text to stay fixed rather than continue calculating from references.

For example, if A1 contains =B1*C1 and currently displays 120, copying A1 and pasting values into D1 puts the result 120 in D1—not the formula. If B1 or C1 changes later, D1 remains 120. If A1 already contains the typed number 120, Paste Values simply copies that value.

Values-only paste does not necessarily mean plain text. A date is stored as a number with a date format, and a percentage is stored as a decimal with percentage formatting. Pasting the value into a General-formatted destination may therefore show a serial number or decimal instead of the familiar date or percentage display. The underlying value may have pasted correctly even if it looks different.

Use the right Paste Values command

In the Windows desktop version of Microsoft 365, try the ribbon first so you can confirm which paste option you selected:

Select the source cells and press Ctrl+C.
Select the top-left destination cell, or a destination range with a compatible shape.
Go to Home > Paste, open the Paste menu, and choose Values. The Values icon commonly shows 123.

Another Windows route is to right-click the destination and choose the Values paste option under Paste Options. If you prefer the dialog, press Ctrl+Alt+V, choose Values, then select OK or press Enter. The V key selects Values in the Paste Special dialog when that option is available.

On Excel for Mac, use Home > Paste and select Values, or use the Paste Special command from the Edit menu. Keyboard shortcuts can differ by keyboard and Excel release; the Windows Ctrl+Alt+V sequence is not the Mac equivalent. On Excel for the web, use the Home tab’s Paste menu and choose a values option. Browser clipboard access and menus can vary, so the ribbon command is a useful alternative when a shortcut is intercepted.

Diagnose the problem in a reliable order

When values seem not to paste, work through these checks before changing workbook settings. They separate a failed paste from a successful paste that merely looks different.

Check the source selection. Press Esc, select the intended cells again, and copy. A moving border around the copied range indicates that Excel has an active copy selection. If you copied a formula cell, inspect its displayed result before pasting.
Click one destination cell. For a first test, select just the top-left destination cell rather than dragging across a large area. Excel normally expands a copied rectangular range from that starting point.
Repeat the command from the ribbon. Choose Home > Paste > Values rather than relying on a keyboard sequence or a menu from another application.
Test a blank worksheet. Copy a simple number or a formula result into an unused cell on a new sheet. If this works, the issue is likely specific to the original destination, its protection, layout, or selection.
Read any error message carefully. Excel messages about differently sized ranges or multiple selections point to a selection problem, not necessarily a broken clipboard.

If the paste appears to do nothing, look at the formula bar as well as the cell display. A value may have replaced a formula even if the number looks identical. Conversely, if the formula bar still begins with an equals sign, the cell still contains a formula; either the wrong paste option was selected or the paste did not occur.

Common causes: range shape, merged cells, and protection

A copied range and a selected destination must be compatible. If you copy a block that is three columns wide and four rows tall, selecting an oddly sized destination or several separate ranges can trigger an error. Start by selecting only the destination’s top-left cell. If you specifically want to fill a chosen range, make sure the copied and destination dimensions match.

Non-adjacent selections can also interfere. For instance, selecting A2:A5 and C2:C5 with Ctrl creates multiple areas rather than one continuous rectangle. Excel may reject a paste into such a selection or report that the action will not work on multiple selections. Paste into a single continuous range instead, or handle each area separately.

Merged cells are another frequent obstacle because a merged area does not behave like a regular grid of individual cells. A copied block may not fit the merged destination’s shape. If practical, unmerge the destination through Home > Merge & Center, paste into a regular range, and then restore the layout. Be careful: unmerging can change how content is arranged, so check the sheet first.

A protected worksheet may prevent editing the destination. If you are authorized to change the workbook, use Review > Unprotect Sheet, entering a password if required, and try the paste again. Do not assume that protection is a clipboard fault: it is a restriction on editing cells. A workbook’s structure protection is different from sheet protection and generally controls changes to sheets, not ordinary cell entry.

Why the result may look wrong after a successful paste

Paste Values preserves the destination’s formatting, so the displayed result may not resemble the source. If a source cell displays 4/5/2026 but the destination displays 46147, the destination may be using General or Number formatting while the pasted date serial is intact. Apply a suitable date format from Home > Number Format. Likewise, a value of 0.25 may display as 25% in a percentage-formatted cell but as 0.25 in a General-formatted cell.

Text that looks numeric can also behave differently from a real number. Imported data may contain a number stored as text, often indicated by a warning marker or left alignment, or it may contain leading spaces. Paste Values transfers the cell value; it does not promise to convert text into a numeric type. If arithmetic or sorting behaves unexpectedly, inspect the source and destination, and use an appropriate conversion method rather than repeatedly pasting.

Errors are values too. If a formula currently returns #N/A or #DIV/0!, Paste Values can freeze that error in the destination. Fix the source formula or input first if you want a usable result. Similarly, if a formula depends on a volatile function or changing inputs, the pasted value is the result at the time of copying; it will not update afterward.

Special cases: tables, filters, and other applications

In an Excel table, a calculated column may automatically fill formulas down the column. This can make a paste seem to have been ignored when Excel is maintaining the table’s formula pattern. Inspect the formula bar in the affected cells. If the cells still contain formulas, check that the Values paste command was used and whether the table’s calculated-column behavior is applying to the range.

Filtered lists require extra care. A filter hides rows from view, but a normal multi-cell paste is not automatically a guarantee that only the visible cells will be changed in the way you intend. Before pasting a block into filtered data, confirm which rows are selected and consider working in an unfiltered copy or handling the visible records deliberately. This helps prevent values from landing in unintended rows.

When copying from a website, PDF, or another application, the clipboard may contain a different structure than expected, such as tab-separated text or formatting. First paste into an empty worksheet to see what Excel receives. If the source is a table of text, use Excel’s import options or paste into a blank area and inspect the columns before overwriting important data. In Excel for the web, browser permissions or the browser’s own shortcut handling can also affect clipboard actions; use the on-screen Paste menu as a check.

Choose between Values and related paste options

Excel offers several paste choices because value, formula, and formatting are separate parts of a cell. The right option depends on what you need to preserve:

Values: transfers results or constants while keeping the destination’s existing formatting.
Formulas: transfers formulas, which may adjust their relative references at the new location.
Values & Number Formatting: transfers the values and their number formats, useful when dates, percentages, or currency should retain their appearance.
Formats: transfers formatting without replacing the destination’s contents.
Transpose: changes rows into columns or columns into rows; it is a layout operation, not a substitute for checking whether values or formulas are being pasted.

These options explain a common misconception: Paste Values does not mean keep the source’s exact appearance. If the goal is to freeze a calculation and keep a date’s display, choose Values & Number Formatting where available, or paste values and then format the destination. If the goal is to keep a live calculation, paste the formula instead.

Ways to avoid repeat problems

Before overwriting a large range, test the operation in one cell and verify both the displayed result and the formula bar. Keep a backup or use a spare worksheet when replacing formulas that may be needed later. After a values-only paste, Ctrl+Z can undo the action in desktop Excel, but do not rely on undo after closing the workbook or performing actions that clear the undo history.

For recurring work, separate calculation cells from final report cells. Keep formulas in a working area and paste values into a clearly labeled output area when a fixed snapshot is required. This makes it easier to identify whether a cell is supposed to update and reduces the risk of replacing a formula that someone still needs. For a one-off result, copying and choosing Values is usually simpler and safer than editing formulas by hand.

Frequently Asked Questions

What is the shortcut for Paste Values in Excel?
On Excel for Microsoft 365 for Windows, press Ctrl+C to copy, then Ctrl+Alt+V, V, and Enter at the destination. If the sequence is unavailable or behaves differently in your setup, choose Home > Paste > Values. On Mac, use the ribbon or Edit menu because the Windows shortcut is different.

Why does Paste Values still show a formula?
Check the formula bar. If it still shows a formula beginning with an equals sign, Excel did not replace it with a value. Copy the source again and explicitly choose Values from the Paste menu; selecting the ordinary Paste command transfers formulas as well as other cell content.

Why did my date turn into a number?
Excel stores dates as serial numbers and displays them using number formatting. The value may have pasted correctly into a destination formatted as General. Apply a date format, or use Values & Number Formatting if you want to bring the source’s number format along.

Can I paste values without copying first?
Paste Values needs something on the clipboard, so copy the source cells first. If you only want to replace a formula in place with its current result, copy the cell and paste Values back onto the same cell or range.

Why does Excel say the copy and paste areas are different sizes?
The source and destination selections are incompatible, or one selection contains multiple areas or merged cells. Try selecting only the destination’s top-left cell, and check that the copied range is a single rectangle that fits the destination.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.