How do I clear contents in my workbook w/o loosing my formulas?
 

I have saved my wookbook, using save as from another file.

How do I clear contents in my workbook w/o loosing my formulas?
 

=IF(OR(A2:A5000={200000,300000,400000}),"YES","NO" )

ctrl+shift+enter, not just enter


"Julie E" wrote:

I have saved my wookbook, using save as from another file.

How do I clear contents in my workbook w/o loosing my formulas?
 

Julie,
I think we've lost what it is you don't want to lose... Please include full
explanation in the text. I'm not sure if Teethless mama was responding to
you or possibly someone else and accidentally got here.

Explain a little more if you don't already have the answer and we'll give it
a go.

"Julie E" wrote:

I have saved my wookbook, using save as from another file.

How do I clear contents in my workbook w/o loosing my formulas?
 

If you want to clear ALL inputs from the sheet without erasing any formulas....
Maybe something like this:

Select only 1 cell

Then...From the Excel main menu:
Press [F5].....(that's the shortcut for <edit<go to)
Click the [Special] button
Check: Constants
Click the [OK] button
(that should select all input cells with values)

Press the [delete] key to erase the contents of those cells

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Julie E" wrote:

I have saved my wookbook, using save as from another file.

How do I clear contents in my workbook w/o loosing my formulas?
 

Julie

CTRL + a(twice in 2003) and F5SpecialConstants.

Select the costants you want to keep and OK

EditClear Contents.


Gord Dibben MS Excel MVP

On Fri, 29 Dec 2006 08:58:00 -0800, Julie E <Julie
wrote:

I have saved my wookbook, using save as from another file.