By Marlo Anderson – The Tech Ranch
Copied totals but the formulas break when you paste them? Press Ctrl + Alt + V, choose Values, and click OK.
The Shortcut
- Ctrl + Alt + V: Paste Special
- Pick Values, Formats, Formulas and more
- Mac: Control + ⌘ + V
Bonus Tip: Google Sheets
In Google Sheets, Ctrl + Shift + V pastes values only. Mac: ⌘ + Shift + V.
More Keyboard Shortcuts, Explained
This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one.
Found this helpful? Give the video a thumbs up on YouTube. Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.
