View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDV JDV is offline
external usenet poster
 
Posts: 3
Default How to save formulas when creating templates

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.