View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Copying worksheet

Do as Mike suggested

"jcinbarrie" wrote in message
...
Thanks, I will try both. I have saved the file as my 2008 expenses, but
the
option (Home/Editing/eraser icon) in xl 2007 doesn't provide a clearing
function that doesn't also wipe out the formulas. I have been desperately
trying to get used to this new version of word and excel, but seem to be
wasting more time trying to figure out ways around it, or just plain old
trying to find how things work. I am so close to going back to 2003.
Sorry for the rant - frustration speaking......
Judy
PS. Tyro, when I try to right clik on the cells I want to clear, and then
"clear content" my formulas go too. The undo button is surely my best
friend
tonight!

"Tyro" wrote:

Sure. Open your 2007 expenses, save it as 2008 expenses. You are now
working
with 2008 expenses. Just select the cells with the numeric values you
want
to clear and delete the values. Just don't delete any formulas. Then save
your workbook as 2008 expenses.

"jcinbarrie" wrote in message
...
Now using excel 2007. I keep an annual (running) list of medical
expenses.
I
would like to copy my 2007 worksheet (created in excel 2003) to use for
2008
expenses. Is it possible to clear the contents of individually selected
cells, like the cost of the medical expense, how much the insurance
reimbursed, and the difference for tax, but maintain the formulas?
Many thanks for any advice,
Judy