Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

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.

Re: Removing data but leaving formulas

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

Re: Removing data but leaving formulas

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?

Re: Removing data but leaving formulas

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

Re: Removing data but leaving formulas

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

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

Re: Removing data but leaving formulas

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

Re: Removing data but leaving formulas

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.