Locking A Formula In A Cell

[Altstatten]

Is there a way to lock a formula in a cell but still be able to delete the
result without deleting the formula?

[Gord Dibben]

To delete the result of a formula, simply delete the data in the cells the
formula references.

=A1 + B1 returns 34

Clear the contents of A1 and B1

To do this en masse, F5>Special>Constants. Uncheck what you want to keep and
OK.

Edit>Clear Contents.


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 11:45:03 -0800, "Altstatten"
<Altstatten@discussions.microsoft.com> wrote:

>Is there a way to lock a formula in a cell but still be able to delete the
>result without deleting the formula?