A real beginner with Excel 2000
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.
|