View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default Erasing contents and leaving the formula

Octavio wrote:
What is the way to leave the formula (sum, etc.) intact after erasing
the contents inside? Where I do set this?
Thanks in advance.


Instead of filling in your blank form copy it to another
worksheet and then fill it in leaving your original intact
to use the next time. A similar process would be to do a
Save As on the original thus creating a new workbook and
then use it.

gls858