Thread: 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 <at>yahoo<dot>com
----
Louise <Louise@discussions.microsoft.com> wrote in message
news:D6D1A515-D254-44E8-8FA2-DD70FB50D397@microsoft.com...
> 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" <Louise@discussions.microsoft.com> wrote in message
news:D6D1A515-D254-44E8-8FA2-DD70FB50D397@microsoft.com...
> 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 <at>yahoo<dot>com
----

Select the range, press F5, select constants, press enter, delete or
edit>clear>contents


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" <Louise@discussions.microsoft.com> wrote in message
> news:D6D1A515-D254-44E8-8FA2-DD70FB50D397@microsoft.com...
> > 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" <Louise@discussions.microsoft.com> wrote in message
news:B2603165-0FF0-42E8-9F30-2209B929DABC@microsoft.com...
> 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" <Louise@discussions.microsoft.com> wrote in message
>> news:D6D1A515-D254-44E8-8FA2-DD70FB50D397@microsoft.com...
>> > 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
>>
>>
>>