Excel - how do I delete data but not formulae?
 

I've got quite a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think
I read somewhere in a magazine that this was possible, but can't now find
how. Any thoughts gratefully received.

Excel - how do I delete data but not formulae?
 

Edit Goto Special and check Constants
Edit Clear Contents
--
Gary''s Student - gsnu200739


"AlanStPaul" wrote:

I've got quite a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think
I read somewhere in a magazine that this was possible, but can't now find
how. Any thoughts gratefully received.

Excel - how do I delete data but not formulae?
 

Great. Just the job. Thanks.

"Gary''s Student" wrote:

Edit Goto Special and check Constants
Edit Clear Contents
--
Gary''s Student - gsnu200739


"AlanStPaul" wrote:

I've got quite a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think
I read somewhere in a magazine that this was possible, but can't now find
how. Any thoughts gratefully received.

Excel - how do I delete data but not formulae?
 

You are quite welcome!
Have a pleasant day!
--
Gary''s Student - gsnu200739


"AlanStPaul" wrote:

Great. Just the job. Thanks.

"Gary''s Student" wrote:

Edit Goto Special and check Constants
Edit Clear Contents
--
Gary''s Student - gsnu200739


"AlanStPaul" wrote:

I've got quite a complicated workbook, and have entered test data to check
it. I now want to delete the test data, but not the various formulae. I think
I read somewhere in a magazine that this was possible, but can't now find
how. Any thoughts gratefully received.