How do I clear a worksheet of values, but leave formulas intact?

P

powers_marilyn

When I choose the option to clear, my formulas are deleted too. Is there a
way to delete values only?
 
J

JulieD

Hi

choose
edit / goto and click on the special button
choose constants (there's some tick boxes you can play with too) and then
click ok
now only the "values" will be selected in your worksheet
now press your delete key

PS always try something like this on a copy of your workbook, just in case
it doesn't work as planned

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"[email protected]"
 
Top