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

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:


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


  2. e.simlaoui says:

    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


  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.


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s