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.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 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.

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

  1. Nigel says:

    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


  2. johnmpl83 says:


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


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


  4. 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 )

Connecting to %s

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