View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default Copying worksheet

jcinbarrie

I don't have 07 but here is how to do it in earlier versions and I am hoping
there is a thread of simularity. F5SpecialUncheck things you want to keep
(like "Text" to keep your headers) and hit OK. All the NON formula cells
will be selected. Review the selection and if it is what you want to delete,
just hit delete. Please, as in all new processes, preform these steps on a
COPY of your sheet until you are comfortable with the proceedure.

Mike Rogers

"jcinbarrie" wrote:

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