erase spreadsheet contents without erasing formulas

[Joseph Meehan]

I am using a spreadsheet for my yearly expenses. I have saved my 2004
spreadsheet, renamed it 2005. Now I want to clear the numbers and
text on that spreadsheet without erasing the formulas that are in
place to start the new year. I do not want to have to set it all up
again. When I highlight the whole thing and select "clear contents",
it erases my formulas also. What am I doing wrong? Thanks for any
help!

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[Guest]

I am using a spreadsheet for my yearly expenses. I have saved my 2004
spreadsheet, renamed it 2005. Now I want to clear the numbers and text on
that spreadsheet without erasing the formulas that are in place to start the
new year. I do not want to have to set it all up again. When I highlight the
whole thing and select "clear contents", it erases my formulas also. What am
I doing wrong? Thanks for any help!