Formula guide · Excel and Google Sheets · Updated May 13, 2026
Paste Values Only in Excel or Google Sheets
Replace formulas with their calculated values without carrying formulas or formatting.
Quick Answer
Use paste values when you want to keep the current result but remove the underlying formula.
Copyable Formula
No formula required. Use Paste special > Values only.Syntax
Copy, then Paste special > Values only.Excel and Google Sheets
Worked Example
| Before | After |
|---|---|
| =A2+B2 | calculated number |
| linked formula | static value |
Result: The cell keeps the visible value and no longer depends on the original formula.
Steps
- Select the formula results.
- Copy the range.
- Use Paste special and choose Values only.
- Save a backup if the formulas may be needed later.
Common Mistakes
- Overwriting formulas before keeping a backup.
- Pasting normal values and accidentally carrying formatting or formulas.
- Freezing results that should continue updating.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.