How to clear cells in a range that have no formulas

[teddavenport]

How do I clear all the cells in a worksheet that have data created by formulas, but leave the formulas intact.

 

[jrnyman]

Not sure this is what you want, but if you select all the cells and format them as hidden; then, protect the worksheet and you won't see the cells, but they'll still be intact.

 

[jrnyman]

Another clever trick is just to make the font color of those cells the same as the background.

 

[Mark W.]

On 2002-04-24 07:44, teddavenport wrote:
How do I clear all the cells in a worksheet that have data created by formulas, but leave the formulas intact.

You question appears to contradict your posting's topic, "How to clear cells in a range that have no formulas". Perhaps your laboring under a misunderstanding of how formulas results are displayed. Care to clarify your question?