View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Copy an XCEL sheet?

Your better off deleting the data in one of your old documents and then
rename workbook as XCEL_BLANK.xls

Then when you need a new Workbook just open up the XCEL_BLANK.xls and before
using save as NewXCEL.xls

That should do it


"Delmer" wrote:

I have a sheet set up which I use quite frequently. How can I copy a sheet
so that all cells are copied ( comments and formulas) but the data I have
entered in the old sheet is not copied. I want the format and formulas
copied but not the data which has been entered into the old sheet.