Question: how to make a formula in excel a value?
Answer: Select all the cells with formulas that you want to convert., Press Ctrl + C or Ctrl + Ins to copy formulas and their results to clipboard., Press Shift + F10 and then V to paste only values back to Excel cells.