Another angle .. maybe you mean selecting just the cells with constants and
clearing these, leaving formula cells alone ?

If so, you might want to try pressing F5 Special Check "Constants" OK
This will select all non-formula** cells in the sheet at one go.
You could then clear with the Delete key.

**unfortunately this might include some row/col labels, etc
besides precedent cells.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Octavio" wrote in message
...
What is the way to leave the formula (sum, etc.) intact after erasing the
contents inside? Where I do set this?
Thanks in advance.