View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.