Clearing Contents but not Formulas

L

Louise

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
 
M

Max

Try:

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

Press "Delete"
 
J

JulieD

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.
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
Top