Do you want to hide the calculated values? Suppose cell B1 is based on A1.
Delete the contents of A1, and change the formula in B1 from
=<whatever
to
=IF(LEN(A1)=0,"",<whatever)
You might consider some kind of unique formatting (e.g. light blue shading)
in A1 and other user-input cells so the user knows where to enter inputs.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"perfection" wrote in message
oups.com...
I wish to use a previous years excel sheet but i need to blank out all
entered and caluclated values present. If i do a complete delete i
will lose all the formulae that have vbeen inserted into certain
formulae. How can i delete all values withour the formulae getting
deleted