Removing data entries but not formulas or formats

J

JD

How do I clear or remove data entries from a worksheet without removing
formulas or formats? The edit, clear content function removes the formulas?

Thanks
 

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

Finding dates without attention to data formats 1
Pop-up: "Too many different cell formats" 3
formula displays as a formula, not as its result 1
Paste special from cells without formulas/formats 2
Formulas Not Calculating Correctly 8
Clear excess formats in Excel 2007 3
remove the cells contents (data) without removing formulas Excel 2 2
Hide columns based on row values 2

Top