Locking A Formula In A Cell

A

Altstatten

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

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
 
Top