You can have a formula in a cell that returns results from other cells.

Or you can a have a value in a cell. Not both at once.

See if F5SpecialConstantsOK does what you want.

This will select cells that aren't formulas.

With those cells selected, EditClear Contents, leaving your formulas behind
waiting to return new results.


Gord Dibben MS Excel MVP

On Mon, 19 Nov 2007 13:12:02 -0800, SliderSteve
wrote:

I have been asked to look at a pronblem with a colleagues spreadsheet in
Excel. When you clear data within a cell, so new data can be added the
formula for teh cell has also been deleted.

Is there a way to set cells to maintain underlying formulas by default?