Shortcut keys
WindowsCtrl + Alt + V → V → Enter
MacCmd + Ctrl + V → V → Enter
Ribbon path
Home → Paste → Paste Values
What it does
Pastes only the cell values, stripping all formulas and formatting. Prevents formula errors when moving data between sheets.
How to use this shortcut
- Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
- Press the shortcut keys shown above for your platform.
- Confirm any dialog options if Excel opens a menu or prompt.
FAQ
What is the Excel shortcut for paste values only?
On Windows, use Ctrl + Alt + V → V → Enter. On Mac, use Cmd + Ctrl + V → V → Enter.
Where is paste values only in the Excel Ribbon?
The Ribbon path is Home → Paste → Paste Values.
What does paste values only do in Excel?
Pastes only the cell values, stripping all formulas and formatting. Prevents formula errors when moving data between sheets.