You can select all formulas using F5SpecialFormulas

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

On Tue, 1 Aug 2006 15:34:01 -0700, BOONER
wrote:

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