Alt + H + V + V in Google Sheets (Paste Values)
Pastes only the values of the copied cells. Formulas are replaced by their results and no formatting comes across.
Add to Chrome (14 Days Free)In Excel: Home tab, Clipboard. In ShortieCuts' key-tip menu: "Values Only".
What Alt + H + V + V Does in Excel
Pastes only the values of the copied cells. Formulas are replaced by their results and no formatting comes across.
The everyday way to hard-code a calculated range, strip links to another workbook, or drop numbers into a template without breaking its formatting.
How to Use Alt + H + V + V in Google Sheets
- Add the ShortieCuts extension to Chrome and open any Google Sheet.
- Select the cells you want to work on (if the command needs a selection).
- Press Alt (or Option on Mac). Excel-style key-tips appear over the sheet.
- Press H, V, then V. ShortieCuts runs Paste Values, just like Excel.
Built-in Google Sheets alternative: Ctrl + Shift + V (Cmd + Shift + V on Mac) also pastes values only.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HVF | Paste FormulasPastes the copied formulas without bringing over the source cells' formatting. |
| Alt HVT | Paste TransposePastes the copied range with rows and columns swapped, so a row of headers becomes a column and vice versa. |
| Alt HVB | Paste All Except BordersPastes everything from the copied cells (values, formulas and formatting) except their borders. |
| Alt HVR | Paste FormattingPastes only the formatting of the copied cells: number formats, fonts, fills and borders. |
| Alt HFP | Format PainterPicks up the formatting of the selected cell so you can apply it to another cell or range. |
| Alt H1 | BoldToggles bold on the selected cells from the Font group of Excel's Home tab. |
| Alt H2 | ItalicToggles italics on the selected cells. |
| Alt H3 | UnderlineApplies underline to the selected cells from the Font group. |
FAQ
Does Alt + H + V + V work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + V + V won't run Paste Values. With the ShortieCuts Chrome extension installed, Alt + H + V + V works in Google Sheets the same way it does in Excel.
What does Alt + H + V + V do in Excel?
Paste Values. Pastes only the values of the copied cells. Formulas are replaced by their results and no formatting comes across.
How do I use Alt + H + V + V on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then V, then V: Option + H + V + V. The same key-tips appear as on Windows.
Is there a built-in Google Sheets shortcut for Paste Values?
Ctrl + Shift + V (Cmd + Shift + V on Mac) also pastes values only.
Is ShortieCuts free?
ShortieCuts has a free 14-day trial with no credit card needed. After the trial, Pro is $7.99 a month or $69.99 a year.