Copying Excel Formulas vs Values: What's on the Clipboard?

An Excel cell can hold a formula, a calculated result, a number format, comments, and data validation at the same time. A normal Ctrl+C offers all of that to the destination. Ctrl+V in another sheet usually pastes the formula (with references adjusted). Notepad usually pastes the displayed result. A web form may paste the display including a currency symbol.

Windows clipboard history does not interpret Excel’s internal formula. If history records the copy, the preview is typically the displayed text. Pasting that history item back into Excel may still carry the richer Office payload — or it may not, depending on what else has been copied since. Do not use Win+V as a formula librarian.

This guide maps what travels, which Paste Special option to pick, and how to keep history from becoming a pile of $1,234.50 ghosts.

What a normal Excel copy contains

Microsoft’s Paste options article lists, among others:

Keyboard: Ctrl+Alt+V opens Paste Special. Then V for values, F for formulas, Enter.

There is also a live preview under Home > Paste. Hover Values (clipboard with 123) versus Formulas (clipboard with fx).

How to copy a number without the currency symbol is the format-versus-value problem when the result is money. Same dialog.

Relative references: the silent rewrite

Copy =A1*1.08 from B1 and paste into B10. Excel pastes =A10*1.08 if the reference was relative. That is usually correct inside one sheet and disastrous when the intent was “always tax cell A1.”

Fixes:

• Use absolute references (=$A$1*1.08) before copying the formula.
• Paste Values if the destination should not compute.
• Use Paste Link only when a live link is required (and both workbooks will stay available).

Array formulas, structured table references ([@Amount]), and names travel with the formula. Pasting into a workbook that lacks the table or name yields #REF! or #NAME?. Values paste cannot #REF!. When in doubt for a handoff file, paste values.

Destination-by-destination

Another range in Excel

• Building a model: paste Formulas (or default paste).
• Snapshot for a meeting pack: paste Values (or Values & Number Formats).
• Same numbers, destination already formatted: Values only, so conditional formatting stays.

Notepad, email, Slack, a terminal

These request text. Excel provides the displayed values, tab-separated for a range, often with a trailing newline. Formulas do not appear unless the cells were formatted to show formulas (Ctrl+ ) at copy time.

A terminal may execute on a newline. Pasting into terminals: always plain text.

Word / Outlook

A range often becomes a table. The table cells are values (displayed), not live Excel formulas, unless an embedded workbook or a link is used. For a one-page report, that is what is wanted. For a “model inside Word,” use a linked or embedded object — not Win+V.

Another app’s import box

Assume it wants values, no currency symbols, no formula text. Helper column + Paste Special Values + Number format, then copy that. How to paste without formatting on Windows will not strip $ if $ is already in the text.

Showing formulas on purpose

To copy the formula *text* into documentation:

1. Select the cell.
2. Copy from the formula bar, not from the cell — that copies the formula as Unicode text.
3. Or toggle Show Formulas (Ctrl+ ), copy the range, paste as text, toggle back.

Those two methods are different:

• Formula bar: one cell, exact characters, no tab grid.
• Show Formulas + copy: a grid of formula strings, good for a README table.

Win+V will then store that text. Fine for a snippet. Do not pin a sheet’s worth of payroll formulas.

Filtered and hidden cells

A normal copy includes hidden cells. The formulas in hidden rows will paste and may surprise the destination. Use Go To Special > Visible cells only (Alt+;) first. How to copy only visible cells in Excel.

Visible-only + Values is the usual “send this filtered view to someone” pair.

What Win+V actually keeps

Office uses the Office Clipboard (up to 24 items inside Office) *and* the Windows clipboard. They are not the same list.

Windows history (Win+V):

• May show $1,234.50 for a formula cell because that is the text preview.
• May not show the formula at all.
• Will not store an .xlsx file as a first-class item if the file was copied in Explorer.
• Drops items over 4 MB. A huge HTML table of a range can miss history while still pasting live.
• Evicts unpinned items after 25 copies and at restart.

Office Clipboard (Home > Clipboard pane in Excel):

• Holds up to 24 Office copies in the Office session.
• Cleared when all Office apps close (typical behavior; do not treat it as a vault).
• Better than Win+V for multiple Excel ranges in one session, still worse than a sheet.

Copying from Excel into Win+V: what you actually keep is the history-focused companion.

Practical rule: if the formula must exist tomorrow, it lives in a workbook. History is for the next paste.

Playbook: send numbers, keep the model

1. Finish calculation in the model workbook.
2. Select the report range.
3. If filters are on, Alt+; .
4. Copy.
5. In a new sheet or workbook: Ctrl+Alt+V > Values (or Values & Number Formats).
6. Save that snapshot with a date in the filename.
7. Do not overwrite the model with values unless that is a deliberate freeze.
8. Clear Win+V if the numbers are confidential.

Playbook: move a formula pattern

1. Convert references to the intended relative/absolute mix.
2. Copy one cell. Paste into the new place. Confirm #REF! is absent.
3. Fill down. Do not copy an entire column through history “just in case.”
4. If the pattern is used daily, it belongs in the template workbook, not in a pinned clip.

An expander can type =VLOOKUP( — that is a snippet. Templates with fill-in fields need an expander. It still will not manage references.

Errors that look like clipboard bugs

Undo (Ctrl+Z) in Excel is still the first response. History is not undo. Clipboard history does not equal undo.

Optional extras

PowerToys Advanced Paste will not “paste as values” inside Excel. It rewrites the Windows clipboard’s text/HTML. Use Excel’s dialog.

A local shelf such as Edge-Drop can hold a PNG of a chart or a CSV export for a slide. It cannot hold a live formula graph. Export the chart; keep the model in .xlsx.

A sensible daily copy-paste workflow is the habit layer around this dialog.

Worked example: monthly snapshot for a slide

The model sheet has =SUMIFS(...) in a totals row. The slide needs last month’s number, not a live link that will change.

1. Confirm the formula bar shows a formula, not a typed number.
2. Copy the totals row.
3. New sheet named snap-2026-07. Ctrl+Alt+V > Values & Number Formats.
4. Copy the snapshot numbers into PowerPoint, or paste the range as a picture if the slide is visual only.
5. Save finance-model.xlsx (formulas) and leave the snapshot sheet in a dated report workbook.
6. Clear Win+V if the figures are internal.

If someone later asks “why does the slide not match the model,” the snapshot sheet is the answer. A history preview of $1,234.50 is not.

Related reading

• How to Paste Without Formatting on Windows
• A Sensible Daily Copy-Paste Workflow
• How to Enable Clipboard History in Windows 11
• Best Clipboard Managers for Windows in 2026

Sources

• Paste options (Microsoft Support) — official Formulas vs Values and related modes.
• Copy and paste using the Office Clipboard (Microsoft Support) — 24-item Office Clipboard, distinct from Win+V.
• Using the clipboard (Microsoft Support) — Windows history limits and formats.
• Create or change a cell reference (Microsoft Support) — relative vs absolute references that rewrite on paste.
• Clear the Clipboard (Microsoft Support) — clearing the Office pane after sensitive ranges.

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