← Back to Blog

Workflows & Productivity | Published Aug 21, 2026 | Updated Oct 13, 2026 | 6 min read

How to Copy Values, Not Formulas, in Excel

By Khushi Yadav

How to Copy Values, Not Formulas, in Excel — Edge Drop Guide

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

  1. Select the cells that contain formulas and press Ctrl+C.
  2. Click the top-left cell of the destination.
  3. On the Home tab, select the arrow under Paste.
  4. 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

  1. Copy the cells with Ctrl+C.
  2. Select the destination and press Ctrl+Alt+V to open Paste Special.
  3. Press V to select Values (or U for Values and number formats).
  4. 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

OptionWhat it pastesUse it when
AllEverything: formulas, formats, commentsCopying within a model
FormulasFormulas only, without formatting or commentsMoving calculations into an already formatted area
ValuesFormula results only, without formatting or commentsSending numbers to someone, freezing a snapshot
Values and number formatsResults plus number formattingA snapshot that should still show currency or dates
Formulas and number formatsFormulas plus number formattingReusing calculations and their display
FormatsFormatting onlyCopying a look, not data
Column widthsColumn widths onlyMatching a layout
Transpose (checkbox)Swaps rows and columnsTurning a row into a column
Paste LinkA reference to the source cellsKeeping 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 typeExampleWhat happens when copied
RelativeA1Row and column both shift
Absolute$A$1Stays the same
Mixed$A1 or A$1Only 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 seeLikely causeFix
#REF! after pastingRelative references point outside the sheet, or a referenced sheet is missingUse absolute references, or paste values
#NAME? after pastingA name or function the destination workbook doesn't havePaste values, or copy the named range too
Numbers turned into datesThe destination cells have a date formatPaste values, then set the number format
Formula shows as textThe destination cell is formatted as TextSet the format to General and re-enter the formula
Pasted values still changeYou used Paste Link, not ValuesPaste 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

Sources

Khushi Yadav
Written by Khushi Yadav · Author & Content Writer

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 · LinkedIn

Copy. 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
Find us on CodeHype