View Single Post
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default How do I clear data values wthout losing the formulas?

Edit Goto Special Constants and then click OK
Edit Clear All
--
Gary's Student


"genaksdal" wrote:

I am attempting to save a workbook as a template. I am to "Clear all the
data values from the section worksheets and then save the workbook as an
Excel template" When I try to clear the data values the formulas disappear
also, which I need to keep for the template. Any help would be appreciated.