Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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. "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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. "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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
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. "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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheet
jcinbarrie
Missed one step .... after you select "special you need to select "constants" then uncheck... Mike Rogers "Mike Rogers" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a formula from one worksheet to another worksheet | Excel Worksheet Functions | |||
Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Copying all formats from worksheet to worksheet | Excel Worksheet Functions | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) |