Converting formulas to values using Excel shortcuts

Just follow the simple steps below:

  1. Select all the cells with formulas that you want to convert.
  2. Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard.
  3. Press Shift + F10 and then V to paste only values back to Excel cells.
  4. Shift + F10 + V is the shortest way to use Excel “Paste special – values only” dialog.