It happens so many times to me when I need to remove the formulas permanently because the Excel worksheet is full of formulas. Don’t worry it is easy to do in Excel. 

Previously In AnalysisLock Cells in Excel

Below I have explained the process step by step to remove formulas in Excel:

Remove Formulas By Copy & Paste Method

Firstly, select all the cells in your Excel sheet that contain all formulas:

Remove Formulas in Excel
After that, select copy option by right-clicking

Once again click Right and select Paste Values

Remove Formulas in Excel

Here you can see that only values are retained and the formulas are gone permanently.

Remove Formulas in Excel