“Copy and Paste Value” is probably one of the most popular actions taken by many people every day. A probably fastest way to do so is definitely worth sharing.
I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts) by MYNDA TREACY
It inspires me to explore more about CTRL C, CTRL V, CTRL, Different shortcuts… And here come this post.
Every time we copy (CTRL C) and paste (CTRL V), we will see the smart tag. Many people will click on it, but even more people will overlook it.
Take a closer look, we see “(Ctrl)”. Isn’t it an obvious sign to prompt us to Press CTRL? By doing so we see the list of the shortcuts displayed as icons. Hover on the icons you will see the description and the respective shortcut key.
Now I understand how “CTRL C, CTRL V, CTRL, V” works.
- 1) CTRL C = Copy; 2) CTRL V = Paste; 3) CTRL to open the list; 4) V is the shortcut key for Value.
- Basically we can follow the same steps for other paste options
- Note: Not applicable to Excel 2003 or before; not yet test on Excel 2007
Below is the list of the shortcuts for quick reference so that you may pick your favorite ones by “CTRL C, CTRL V, CTRL, ?” where ? is any one the following:
From Left to Right, Top to Down
- P – Paste
- F – Formulas
- O – Formulas and Number Formatting
- K – Keep Source Formatting
- B – No Boarders
- W – Keep Source Column Width
- T – Transpose
- V – Values
- A – Values and Number Formatting
- E – Values and Source Formatting
- R – Formatting
- N – Paste Link
- U – Picture
- I – Linked Picture
Most of the above are quite self-explanatory. Nevertheless W (Keep Column Width) and I (Linked Picture) are two not so well known and worth mentioning. Let’s discuss about it in my next post. See ya.
Learning is a process of observation, experiment, application and sharing.