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.
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:
Once again click Right and select Paste Values
Here you can see that only values are retained and the formulas are gone permanently.