A real beginner with Excel 2000

I

ian.runnacles

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

Mike H

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
 
P

Pete_UK

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
 
D

Dave Peterson

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