Google Sheets · Paste values only
Clipboard
Windows · Linux
Ctrl+Shift+VMac
Cmd+Shift+VPastes only the values, leaving formatting and formulas behind; it is what stops colours and fonts riding along when you copy a table from a web page.
- Group
- Clipboard
- Keys held
- 3
It runs inside the browser, so combinations the browser claims first — Ctrl+W, for one — never reach the sheet. That is why so many Sheets shortcuts use Alt/Option.
Reading the key names
- Keys joined by + are pressed together: Ctrl+Shift+P means hold Ctrl and Shift, then P.
- On a Mac, Cmd is ⌘, Option is ⌥ (labelled Alt on some keyboards), Control is ⌃ and Shift is ⇧.
- Windows Ctrl usually becomes Cmd on a Mac, but not always — this reference lists both combinations separately.
- With a Korean, Japanese or Chinese input method active, shortcuts built on letter keys may not fire. Switch to Latin input and try again.
- When a combination does nothing, another program has often claimed it as a global shortcut first.
Common questions
Q. What is the shortcut for Paste values only in Google Sheets?
Pastes only the values, leaving formatting and formulas behind; it is what stops colours and fonts riding along when you copy a table from a web page. It is Ctrl+Shift+V on Windows and Cmd+Shift+V on a Mac.
Q. Is it the same on Windows and Mac?
No — Ctrl+Shift+V on Windows, Cmd+Shift+V on a Mac.
Q. How many keys is that?
3 pressed together. The combination sits under Clipboard in Google Sheets.