View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bmartucci bmartucci is offline
external usenet poster
 
Posts: 1
Default Clone worksheets?

I'm not too Excel literate, but is there a way to basically clone an Excel
worksheet without the values? I know you can do this with databases. I have
sheets I use from year to year and hate to do a Save As and then clear out
all the values, or a copy, and then clear the values, or data. I tried the
Paste Special tab, but the values/data still transfer over. I want to retain
my column headings and categories, and formulas, nothing else.
Thanks.
--
B Martucci