## Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V

“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
• U – 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.

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Shortcut and tagged , , , , . Bookmark the permalink.

### 5 Responses to Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V

1. johnmpl83 says:

Hi!

You can use the Ctrl + C and latter “Menu Button” V. Blessings!

Like

• MF says:

Hi John,
That is nice. The only drawback is we have to use both hands for this trick. 🙂
Cheers,

Like

2. e.simlaoui says:

awesome.
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

Like

• MF says:

You are welcome.
Thanks for sharing the F2 and F9 trick! 🙂

Like

3. Jens says:

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.

Like

This site uses Akismet to reduce spam. Learn how your comment data is processed.