Question: how to make a formula into a value in excel?
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.