“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.
Is there a way to covert a cell from formula to value at given date and time every day.
I have cells that automatically update share prices from the share market using DATA> DATA TYPES>STOCKS
I would like to convert a cell from formula to value to reflect the closing price or “value” of the formula everyday after the market has closed.
I have been using CTRL C, CTRL V, CTRL, V everyday but would like this process automated.
Your assistance would be greatly appreciated
You can use the Ctrl + C and latter “Menu Button” V. Blessings!
That is nice. The only drawback is we have to use both hands for this trick. 🙂
thank you for shating your knowledge.
if you have just one cell and you want to copy value instead of formula in this cell ; just try this quick trick
F2 then F9 then ENTER
have a nive day
You are welcome.
Thanks for sharing the F2 and F9 trick! 🙂
This didn’t work. But i found out, that I need to Change my Excel options. There are special options for copy & paste. Unfortunately I don’t know the description in english.