Assuming, of course, that the precedents cells do not have formulas of their
own in them.

--
Rick (MVP - Excel)


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Clear the precedents cell(s)

i.e. formula in B1 is =SUM(A1:A10)

Clear A1:A10


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 09:49:02 -0800, djh
wrote:

How can I clear the results of a formula from a cell without deleting the
formula itself?