<div>
press Control + G<br />
<br />
then click Special<br />
<br />
then select formulas <br />
<br />
then all of the cells with formula in active sheet will be selected, then press delete
</div>


press Control + G

then click Special

then select formulas

then all of the cells with formula in active sheet will be selected, then press delete

<div>
It worked for me. Thank you very much. Great help.
</div>


It worked for me. Thank you very much. Great help.

<div>
<div class="content wysiwyg-content">
How to remove formula used in excel sheet.<br />
<br />
example: There is one attendance sheet in which formula is applied for calculation of total hour an employee worked.<br />
<br />
I want to remove that formula. How it can be done. please help me<br />
<br />
Regards<br />
Sanjeev
</div>
</div>


How to remove formula used in excel sheet.

example: There is one attendance sheet in which formula is applied for calculation of total hour an employee worked.

I want to remove that formula. How it can be done. please help me

Regards
Sanjeev

Microsoft Excel 2010

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.