Clear Contents But Not Formula

[Guest]

I want to use a complicated worksheet that was devised for last year but
contents will now change to this year. How can I clear the contents of the
cells, the numbers, but leave the formula remaining?

 

[JulieD]

Hi

click in the sheet you want to do this in (please try on a copy of your
workbook first), choose edit / goto, click the special button and then check
"constants" .. there's some tick boxes you can play with too ... then click
OK and press the delete key.

Hope this helps
Cheers
JulieD

 

[Dave Peterson]

Just to add to JulieD's response.

If you have constant cells that you don't want to clear, then be a little
careful.

Select the area that is ok to clear (avoid headers/descriptions/etc).

Then do the Edit|Goto stuff that JulieD described.