Paste Values in Excel
Paste Values lets you paste only the final results of cells without copying formulas, formatting, or links. This is essential when sharing data or cleaning Excel files.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Alt + V, V, Enter | Cmd + Ctrl + V, V, Enter |
What Does Paste Values Do?
This option pastes only the displayed values from copied cells, removing all formulas, references, conditional formatting, and data validation.
When Should You Use Paste Values?
- To break formula links
- Before sharing files with others
- When importing data from external sources
- To improve workbook performance
How to Paste Values (Step-by-Step)
- Copy the cells using Ctrl + C
- Select the destination cell
- Press Ctrl + Alt + V
- Press V
- Press Enter
Alternative Paste Values Shortcuts
- Windows: Right-click → Paste Values (123 icon)
- Mac: Right-click → Paste Values
FAQ
- Q: Does Paste Values remove formatting?
- Yes, it pastes only the raw values.
- Q: Is Paste Values faster than normal paste?
- Yes, especially in large workbooks.