Clearing Contents but not Formulas
 

Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise

Try:

Press F5 Constants OK
(think this selects cells other than those with formulas)

Press "Delete"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Louise wrote in message
...
Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise

Hi Louise

choose your worksheet then choose
edit / go to click on the special button
choose constants
you have some tick boxes you can play with, then press OK
now press the delete key.

hope this helps
Cheers
JulieD
PS please backup your workbook before trying this.

"Louise" wrote in message
...
Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise

Correction, sorry:
Press F5 Constants OK

should read:
Press F5 Special Constants OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Select the range, press F5, select constants, press enter, delete or
editclearcontents


Regards,

Peo Sjoblom

"Louise" wrote:

Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise

Hi

Thanks very much. It worked a treat.

Louise

"JulieD" wrote:

Hi Louise

choose your worksheet then choose
edit / go to click on the special button
choose constants
you have some tick boxes you can play with, then press OK
now press the delete key.

hope this helps
Cheers
JulieD
PS please backup your workbook before trying this.

"Louise" wrote in message
...
Hi all

Does anybody know if it is possible to select a worksheet and delete the
contents but leave the formulas alone?

Thank you.

Louise

Hi Louise

you're welcome and thanks for the feedback

Cheers
JulieD

"Louise" wrote in message
...
Hi

Thanks very much. It worked a treat.

Louise

"JulieD" wrote:

Hi Louise

choose your worksheet then choose
edit / go to click on the special button
choose constants
you have some tick boxes you can play with, then press OK
now press the delete key.

hope this helps
Cheers
JulieD
PS please backup your workbook before trying this.

"Louise" wrote in message
...
Hi all

Does anybody know if it is possible to select a worksheet and delete
the
contents but leave the formulas alone?

Thank you.

Louise