View Single Post
  #3   Report Post  
Old June 18th 07, 12:32 PM posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default How to delete cell values withour deleting cell formulae

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