How to remove formulas in excel


Staff member
Remove Formulas in Excel (and Keep the Data)
  1. Select the cells in column C that have the formula.
  2. Right-click on any of the selected cells and click on Copy (or use Control + C)
  3. Again click on any cell in the selection and right-click.
  4. Click on the Paste Special option. ...
  5. In the 'Paste Special' dialog box, select 'Values'
  6. Click OK.