Dave

EditGo To(or F5)SpecialConstants. Tickmark what you want selected then OK
your way out.

EditDelete what is highlighted.

Gord Dibben Excel MVP

On Sat, 1 Jan 2005 20:15:03 -0800, "Dave"
wrote:

I can delete data, but it delets the formula. Is there any way to lock a
formula, but can still clear data?

Thanks