Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete data in worksheet, but not the associated formula
trying to use an already created worksheet as a template, deleting the data
but do not want to delete the formulas associated with the cells. how? |
#2
|
|||
|
|||
First select All by presing Ctrl+A
then pres Function key F% on ypur keyboard click on Special... select constants press the delete key on the keyboard "cganno" wrote in message ... trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? |
#3
|
|||
|
|||
I bet that there are labels (titles/descriptions/etc) that you want to keep to.
Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete data in worksheet, but not the associated form
I too want to do this: delete the data in a worksheet (that I worked very
hard on) and use this worksheet with all the formulas in tact as a template. I did as you said and it won't clear the data from the cells that have formulas in them without clearing the formulas as well. Thanks, Corinne "Dave Peterson" wrote: I bet that there are labels (titles/descriptions/etc) that you want to keep to. Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete data in worksheet, but not the associated form
What I would do.............a bit differently than Dave<g
Select all cells then F5SpecialConstants. Uncheck all but "Numbers" and OK your way out. Touch nothing except the Delete key Numbers gone. Formulas and text remain. Note: you may have errors showing in formula cells which have no data to source. Gord Dibben MS Excel MVP On Wed, 17 Dec 2008 13:01:03 -0800, Corinne wrote: I too want to do this: delete the data in a worksheet (that I worked very hard on) and use this worksheet with all the formulas in tact as a template. I did as you said and it won't clear the data from the cells that have formulas in them without clearing the formulas as well. Thanks, Corinne "Dave Peterson" wrote: I bet that there are labels (titles/descriptions/etc) that you want to keep to. Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete data in worksheet, but not the associated form
Only different because I am assuming your data to remove was numeric only.
Otherwise.........follow Dave's instructions. Gord On Wed, 17 Dec 2008 13:56:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote: What I would do.............a bit differently than Dave<g Select all cells then F5SpecialConstants. Uncheck all but "Numbers" and OK your way out. Touch nothing except the Delete key Numbers gone. Formulas and text remain. Note: you may have errors showing in formula cells which have no data to source. Gord Dibben MS Excel MVP On Wed, 17 Dec 2008 13:01:03 -0800, Corinne wrote: I too want to do this: delete the data in a worksheet (that I worked very hard on) and use this worksheet with all the formulas in tact as a template. I did as you said and it won't clear the data from the cells that have formulas in them without clearing the formulas as well. Thanks, Corinne "Dave Peterson" wrote: I bet that there are labels (titles/descriptions/etc) that you want to keep to. Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete data in worksheet, but not the associated form
Thanks for getting back to me so quickly. I did exactly as was outlined (as a
reference, I am using this in a payroll worksheet I made up) all the cells that have formulas in them, the data would not clear, but the cells -- with payroll dates -- did clear. The only thing I did differently was I did not select all the cells, I chose only the cells that have data in them that would change each quarter, so the text cells with their personal information I did not choose. I chose these cells by using the shift and arrow keys. I hope this extra information will help you to help me. Thanking you in advance, Corinne. "Gord Dibben" wrote: Only different because I am assuming your data to remove was numeric only. Otherwise.........follow Dave's instructions. Gord On Wed, 17 Dec 2008 13:56:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote: What I would do.............a bit differently than Dave<g Select all cells then F5SpecialConstants. Uncheck all but "Numbers" and OK your way out. Touch nothing except the Delete key Numbers gone. Formulas and text remain. Note: you may have errors showing in formula cells which have no data to source. Gord Dibben MS Excel MVP On Wed, 17 Dec 2008 13:01:03 -0800, Corinne wrote: I too want to do this: delete the data in a worksheet (that I worked very hard on) and use this worksheet with all the formulas in tact as a template. I did as you said and it won't clear the data from the cells that have formulas in them without clearing the formulas as well. Thanks, Corinne "Dave Peterson" wrote: I bet that there are labels (titles/descriptions/etc) that you want to keep to. Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I delete data in worksheet, but not the associated form
Sorry, I just had a thought and my response isn't even up
yet.....but....could I "copy" just the formulas, then delete the data, then "paste" the formulas back in. I'm not sure if that is an option - copying just he formulas, but that would be great. Thanks again. Corinne "Gord Dibben" wrote: Only different because I am assuming your data to remove was numeric only. Otherwise.........follow Dave's instructions. Gord On Wed, 17 Dec 2008 13:56:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote: What I would do.............a bit differently than Dave<g Select all cells then F5SpecialConstants. Uncheck all but "Numbers" and OK your way out. Touch nothing except the Delete key Numbers gone. Formulas and text remain. Note: you may have errors showing in formula cells which have no data to source. Gord Dibben MS Excel MVP On Wed, 17 Dec 2008 13:01:03 -0800, Corinne wrote: I too want to do this: delete the data in a worksheet (that I worked very hard on) and use this worksheet with all the formulas in tact as a template. I did as you said and it won't clear the data from the cells that have formulas in them without clearing the formulas as well. Thanks, Corinne "Dave Peterson" wrote: I bet that there are labels (titles/descriptions/etc) that you want to keep to. Select the range to clean--don't include any of those labels to be kept. Edit|Goto|Special click Constants and OK hit the delete key on the keyboard. cganno wrote: trying to use an already created worksheet as a template, deleting the data but do not want to delete the formulas associated with the cells. how? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print report with data from specific worksheet | Excel Discussion (Misc queries) | |||
Pivot table of data in more than one worksheet | Excel Discussion (Misc queries) | |||
Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
extract data from worksheet | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |