Remove Formuli

B

BOONER

Is there a way to remove all formulas from a workbook or sheet without copy
and paste-values?
 
E

Excelenator

Do you want to delete the formulas and their values (i.e. clear the
cells containing formulas)?

If so you can use F5\Special\Formulas and then hit the delete key.
 
G

Gord Dibben

You can select all formulas using F5>Special>Formulas

But you cannot delete/remove them without losing the results of those formulas
unless you copy/paste values first or deal with them through VBA code.

Sub test()
For Each cell In Selection
If cell.HasFormula Then
cell.Value = cell.Value
End If
Next
End Sub


What do you wish to do. Perhaps we could help.


Gord Dibben MS Excel MVP
 
Top