Copy an XCEL sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
And an easy way to delete your data is to hit the F5 key to bring up the goto
dialog box, click on Special, then check constants and uncheck all options
except numbers and text, then click OK. All of your input data should be
selected so just hit delete then 'save as' Blank Master or whatever.
Depending on how your sheet is set up you may want to uncheck text as well
or you will lose headers and titles etc.

HTH
Martin
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
advise on how to import data into excel sheet 1
problem with fractions to decimal 1
Macro to copy value in field and insert it into filter 2
Copy Exact Formula 1
copy rows from one Data sheet to another sheet based on cell conte 2
problems getting this macro to work 23
How can I copy page set up options from one sheet to another 1

Back
Top