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

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

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]"
<[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
> When I choose the option to clear, my formulas are deleted too. Is there
> a
> way to delete values only?

Hi

1. Select one cell on the relevant worksheet.
2. Press F5 and select "Special"
3. Select "Constants" from the dialog box.
4. Select "OK"
5. Hit the "Delete" button on your keyboard.

--

-----
XL2003
Regards

William
[email protected]


"[email protected]"
<[email protected]@discussions.microsoft.com> wrote in message
news:[email protected]...
> When I choose the option to clear, my formulas are deleted too. Is there
> a
> way to delete values only?