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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Content Control Box Issue - Please Help! 0
Adding Heading to Table of Contents after a column break 1
Lost my Table of Contents , Appendices and Page numbers ? 2
Problems created by Recent updates to Outlook 365 0
Copy the content of a cell with Formula 1
Vertical short line in front of word 0
Copy addition formula of non-consecutive horizontal cells 2
Excel found unreadable content in file error. 0

Top