How to Copy Values, Not Formulas, in Excel
By Khushi Yadav
To copy values instead of formulas in Excel, copy the cells with Ctrl+C, click where you want them, then select Home > Paste > Values. From the keyboard, press Ctrl+Alt+V to open Paste Special, press V for Values and then Enter. Excel pastes the formula results without the formulas, formatting or comments. To keep the number formatting (currency, dates, percentages), choose Values and number formats instead.
Paste values with the mouse
- Select the cells that contain formulas and press Ctrl+C.
- Click the top-left cell of the destination.
- On the Home tab, select the arrow under Paste.
- Choose Values, or Values & Source Formatting to keep the look of the original cells.
Hovering over each icon previews the result before you commit.
Paste values with the keyboard
- Copy the cells with Ctrl+C.
- Select the destination and press Ctrl+Alt+V to open Paste Special.
- Press V to select Values (or U for Values and number formats).
- Press Enter.
To turn formulas into values in place, copy the range and paste values over the same range. Do this on a copy of the sheet if you might need the formulas later; once overwritten, they're gone after you save. It's also the last step after fixing capitalisation with UPPER, LOWER or PROPER; see how to change the case of pasted text.
Which Paste Special option to use
| Option | What it pastes | Use it when |
|---|---|---|
| All | Everything: formulas, formats, comments | Copying within a model |
| Formulas | Formulas only, without formatting or comments | Moving calculations into an already formatted area |
| Values | Formula results only, without formatting or comments | Sending numbers to someone, freezing a snapshot |
| Values and number formats | Results plus number formatting | A snapshot that should still show currency or dates |
| Formulas and number formats | Formulas plus number formatting | Reusing calculations and their display |
| Formats | Formatting only | Copying a look, not data |
| Column widths | Column widths only | Matching a layout |
| Transpose (checkbox) | Swaps rows and columns | Turning a row into a column |
| Paste Link | A reference to the source cells | Keeping a live link to the original |
Skip blanks keeps existing values in the destination wherever the copied range has blank cells.
Copy formulas without breaking references
When you copy a formula, Excel adjusts relative references to the new position. Copy =A1*1.08 from B1 to B10 and it becomes =A10*1.08.
| Reference type | Example | What happens when copied |
|---|---|---|
| Relative | A1 | Row and column both shift |
| Absolute | $A$1 | Stays the same |
| Mixed | $A1 or A$1 | Only the part without $ shifts |
To fix a reference before copying, select it in the formula bar and press F4 to cycle through the reference types.
Formulas that use sheet names, table names or defined names can return #REF! or #NAME? when pasted into a workbook that doesn't have them. If the destination only needs the numbers, paste values and the problem can't occur.
Copy a formula as text
Sometimes you want the formula itself as text, for documentation or a message.
- One formula: click the cell, select the formula in the formula bar, and copy it. You get exactly the characters, with no cell grid.
- A range of formulas: press Ctrl plus the grave accent key (the key above Tab on US keyboards) to show formulas instead of results, copy the range, then press the same shortcut again to switch back.
Pasting Excel data into other apps
Apps that accept only text, such as Notepad, chat apps, terminals and many web forms, receive the values as they appear in the cells, tab-separated, not the formulas. If a number shows a currency symbol or thousands separator in Excel, that text usually comes along. How to copy a number without the currency symbol covers that case, and how to paste without formatting on Windows covers plain-text pasting in general.
Word and Outlook usually turn a pasted range into a table of the displayed values. For live numbers in a document, use a linked object instead.
Filtered ranges: copy visible cells only
When rows are hidden or filtered, use Home > Find & Select > Go To Special > Visible cells only before copying, so the hidden rows don't come along. Combined with Paste Values, this is the standard way to send someone a filtered view. How to copy only visible cells in Excel has the details.
Excel, the Office Clipboard and Win+V
Office has its own Office Clipboard, which holds up to 24 items you copy and lets you paste any of them into any Office app. Open it from the dialog box launcher in the Clipboard group on the Home tab. It's separate from Windows clipboard history.
Windows clipboard history (Win+V) stores text, HTML and bitmap items, so an Excel range in history may not paste back into Excel exactly like the original copy, and the history preview shows displayed values rather than formulas. For moving formulas between workbooks, copy and paste directly in Excel. Copying from Excel into Win+V explains what history keeps, and how to stop the Office Clipboard taking over history covers the pane popping up.
When the paste goes wrong
| What you see | Likely cause | Fix |
|---|---|---|
#REF! after pasting | Relative references point outside the sheet, or a referenced sheet is missing | Use absolute references, or paste values |
#NAME? after pasting | A name or function the destination workbook doesn't have | Paste values, or copy the named range too |
| Numbers turned into dates | The destination cells have a date format | Paste values, then set the number format |
| Formula shows as text | The destination cell is formatted as Text | Set the format to General and re-enter the formula |
| Pasted values still change | You used Paste Link, not Values | Paste values instead |
Ctrl+Z undoes a paste in Excel. Clipboard history isn't an undo tool; clipboard history does not equal undo explains the difference.
FAQ
What is the shortcut to paste values in Excel?
Press Ctrl+Alt+V, then V, then Enter. Alt+E, S also opens Paste Special.
How do I copy a formula without changing the cell references?
Make the references absolute with $ (select the reference and press F4), or copy the formula text from the formula bar and paste it into the new cell.
How do I convert a whole column of formulas to values?
Select the column, copy it, and paste Values over the same column. Keep a backup if you may need the formulas again.
Related reading
- How to Copy Only Visible Cells in Excel (Alt+;)
- Excel and Clipboard History: What Win+V Actually Keeps
- How to Copy a Number Without the Currency Symbol
- How to Paste Without Formatting on Windows
Sources
- Paste options (Microsoft Support) — Paste menu and Paste Special options, Ctrl+Alt+V, Skip blanks, and how references change when copied.
- Keyboard shortcuts in Excel (Microsoft Support) — Ctrl+Alt+V, Alt+E+S, the V and U keys in Paste Special, and Ctrl+grave accent to show formulas.
- Create or change a cell reference (Microsoft Support) — relative and absolute references.
- Copy visible cells only (Microsoft Support) — Go To Special > Visible cells only.
- Copy and paste using the Office Clipboard (Microsoft Support) — the 24-item Office Clipboard.
- Using the clipboard (Microsoft Support) — formats stored by Windows clipboard history.
Khushi Yadav writes Edge Drop's workflow and design guides and is a B.Tech Computer Science Engineering student. Khushi's posts are checked against Microsoft's documentation and the Edge Drop fact sheet.
GitHub · LinkedInCopy. Stack. Drop.
Transform your clipboard into an interactive edge shelf. Stack, pin, and drag assets into any app with zero friction.
Download for Windows Get from Microsoft Store
How to Install Guide · First 10 Minutes Guide · Drag & Drop Guide · Edge Drop vs Win+V · Support
Free · Lightweight · Privacy First