View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 46
Default Copy an XCEL 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