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.

Hi,

Select the cells and copy them then in another area of the worksheet
Edit|Pastespecial
select values and click OK
The values that the formula produced are now saved as values and won't
change when you update the data that produced those values.

Mike

" 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.

If you press F5 (GoTo) then click on Special and then Constants, Excel
will select all the constant values in your sheet. Press the <Delete
key to remove them, leaving your formulae intact. Use File | Save As
to save the (blank) file with a different name.

Note that you may have some errors showing if you have no data - #DIV/
0 for example - but these will disappear when you add your current
data to the sheet.

Hope this helps.

Pete

On Apr 16, 12:28*pm, 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.

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