Removing data but leaving formulas

Posted by ed dalton on December 29, 2001 9:48 PM

I have a spread sheet that I want to remove the data entries but keep the formulas. I can't seem to delete the entries without also loosing the formulas. Any help will be greatly appriciated.

Posted by Jacob on December 29, 2001 10:08 PM

What do you mean. If there is a formula in A1 and you delete it, it will be gone? If you delete something else it will still be there. Post some more info and I will try to help.

Jacob

Posted by dalton on December 29, 2001 10:44 PM

Thanks.
For example: I post data to a group of cells and there are formulas associated with them. I wish to duplicate the spread sheet and formulas for the next months business entries. I now need to delete the data from last month, keep the formulas in place and add new data for the next month. When I delete the data, the formulas go with it. Do I need to isolate the formula cells and not delete them thereby keeping the formulas in place?

Posted by Jacob on December 30, 2001 4:39 AM

Basically yes. Just highlight all of the data you input and delete it. Then input the new data and the formulas will still be there.

Jacob

Posted by Paul on December 30, 2001 5:04 AM

You can also try edit, goto, special, constants, and then delete

Posted by Ivan F Moala on December 30, 2001 9:42 PM

OR just
Edit | Goto | Special
select CONSTANTS
Deselect; Text,Logical,Errors

Then click OK

Ivan

Posted by Ivan F Moala on December 30, 2001 9:43 PM

OR just
Edit | Goto | Special
select CONSTANTS
Deselect; Text,Logical,Errors

Then click OK

Then Delete

Ivan