If you're creating a new workbook, just open the old file and do
File|SaveAs
(and save as a nice name)

If you're creating a new worksheet in the existing workbook, select the sheet to
copy and
Edit|Move or copy sheet
Click the "Create a copy"
(Change the name of the new sheet to something nice)

In either case, once you've got the new worksheet, you can select the range to
clean up.
(Be a little careful--avoid the headers, but you can include the formulas since
you'll avoid them in the next step.)

Edit|Goto|Special
Check constants
click Ok
Verify that only the cells you want cleaned up are selected.

Hit the delete key if it's ok.

You can use this technique on a bunch of small ranges if you want.

wrote:

I want to reuse a table for my tax returns for last year but without
the data entries. I need to keep the underlying formulae, so how do I
save a copy of the existing one, empty the cells but leave the
framework - columns, cell functions etc so I can start the new year
with a clean sheet?
Sorry to ask such a silly question. Imagine you are talkiing to a five
year old and thanks very much for your time and your reply.

Greetings from England,

Ian.

--

Dave Peterson