1
Ctrl + CCopy the source data
Start with a normal copy — same as always.
PastePaste SpecialPaste Values
Master Ctrl+Alt+V (Paste Special) for Lightning-Fast Workflows
Paste mistakes in Excel usually come down to one thing: pressing Ctrl+V without deciding what you actually want to keep. Learning Ctrl+Alt+V eliminates that problem.
Shortcuts you will master in this article
Ctrl + Alt + V / Ctrl + C / Ctrl + V
Paste Errors Happen Because 'Paste Everything' Is the Default
Broken formulas pasted in by mistake, formatting that ruins the layout, cell references you didn't mean to carry over — most paste errors in Excel come from not choosing what to paste.
Once you know Ctrl+Alt+V, you start treating paste as a deliberate choice rather than a reflexive action.
How to Use Paste Special
Paste Values is the most commonly used option, but learning to separate formulas and formatting from values is worth the extra minute.
2
Ctrl + Alt + VOpen Paste Special
This lets you choose exactly what to paste before committing.
3
V / EnterPaste values only
Use this when you want to keep the results of a formula without keeping the formula itself. Also prevents broken references.
4
T / Enter (etc.)Paste formatting or formulas as needed
Switch between paste types depending on the situation — that flexibility is the whole point.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
When to Use Paste Special
When passing results to another workbook, Paste Values should be your default.
Use it when you want to copy only formatting or only formulas from another range.
Building the habit of not reaching for Ctrl+V by default reduces layout breakage and reference errors before submission.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + C | Copy |
Ctrl + V | Paste |
Ctrl + Alt + V | Paste Special |
Frequently Asked Questions
Q. Which paste option do you use most in real work?
A. Paste Values, by far. There are always situations where you want to sever the link to the source workbook.
Q. Which key should I learn after Ctrl+Alt+V?
A. Just lock in the Values shortcut first. Expand to formatting and formulas once that's automatic — trying to learn everything at once causes confusion.
Q. Can I use this to update cell content without changing the formatting?
A. Yes. Pasting values only lets you update the data while preserving the colors, borders, and layout of the destination.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →