Not sure if you mean workbook or worksheet, and assuming you mean you want to
keep formats...

Are you meaning an Excel 2007 file? If so, from the home tab, on the right,
just left of the Sort & Filter, click the drop-down on the eraser. Select
Clear Contents.


"cecorjon" wrote:

I want to be able to copy a 2009 file, keeping all the formulas and
templates, but I also want to erase all the data--without having to go into
each cell and delete it. Is this possible, and how can I do it?