How to clear cells in a range that have no formulas

teddavenport · Apr 24th, 2002, 08:44 AM

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

jrnyman · Apr 24th, 2002, 08:47 AM

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 · Apr 24th, 2002, 08:47 AM

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

Mark W. · Apr 24th, 2002, 09:22 AM

Quote:

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 08:44 AM	#1
teddavenport New Member Join Date: Apr 2002 Location: Ted Davenport Posts: 10	How do I clear all the cells in a worksheet that have data created by formulas, but leave the formulas intact.

Apr 24th, 2002, 08:47 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	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.