Copying worksheet

[jcinbarrie]

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

 

[Tyro]

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.

 

[Tyro]

Or if you want to keep your 2007 and 2008 expenses in the same workbook,
just copy the 2007 expense sheet (select the sheet, hold Ctrl and drag left
or right to make a copy) and rename it 2008 expenses and then and on the
2008 expenses sheet just clear the numeric values and leave the formulas
alone.

 

[Mike Rogers]

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. F5>Special>Uncheck 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]

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]

Do as Mike suggested

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]

Also, as additional help, press Ctrl+` (the leftmost key in the row above
the tab key). Doing show will show all formulas and values on your sheet.
Press Ctrl+`, to resume normal display.

 

[Tyro]

Also. Press F5. Select Special. Select Constants. Clear anything you don't
want selected in Numbers, Text, Logicals and Errors. Press Ok. All
non-formula cells and anything you did not clearwill be selected. Visually
verify as my previous post with Ctrl+`. If it looks good, press Delete! And
presto, gone! You may lose some text you didn't want to lose, such as
headings but once you re-enter those (copy, paste from backup copy), you'll
have them and all of your formulas. Just be very sure to have a backup copy
of your workbook before doing this.

 

[Mike Rogers]

jcinbarrie

Missed one step .... after you select "special you need to select
"constants" then uncheck...

Mike Rogers