View Single Post
  #1   Report Post  
DarrellK
 
Posts: n/a
Default URGENT Please... new worksheet with copied formats but no data.

I use Excel 2003. I track mothly sales data. Each month I add a new
worksheet, I want to transfer the borders, column widths, formats, and
fomulas only, but I want to delete the previous month's data so I can fill in
the data as the new month progresses. I can "special paste" but everything
transfers. How Can I delete ONLY the enterd data on a whole worksheet while
preserving the formats, formulas, etc.
TIA