Clearing contents without deleting formulas

[Guest]

I need to know how to clear the contents of multiple cells without deleting the formulas. I know I can do this, just can't figure it out. Thansk!

 

[Ron de Bruin]

Hi Wendy

F5
Constants
Ok
Press the delete key

--
Regards Ron de Bruin
http://www.rondebruin.nl

I need to know how to clear the contents of multiple cells without deleting the formulas. I know I can do this, just can't figure

it out. Thansk!

 

[Anne Troy]

You can't really do that. Your formulas should be written to result in "" if
the cells on which you would otherwise perform a calculation are blank.

So, consider this: If you have a number in D2, and you're running a
calculation on it, a formula like this will show nothing in the cell if D2
is empty:

=if(isblank(d2),"",d2*4)

So, you really want to have THOSE kinds of formulas, and the clear the
contents of the cells that contain the values on which the formulas are
based.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

I need to know how to clear the contents of multiple cells without

deleting the formulas. I know I can do this, just can't figure it out.
Thansk!

 

[Jack Sons]

Wendy,

If the content of the cell is the result of the formula in that cell, you
can clear the formula and keep the result (see Ron de Bruin's answer), but
not the other way round (which is what you requested) because clearing the
cell will also clear its formula.

Sometimes I take for a workaround writing (copying) the formula into the
comment of that cell. Especially if the formula's are filled down for some
or many rows of a table, I put the formulas into the cell comments of the
cells of the first row (with the column headers or field names). When the
table is cleared the top row will almost always be kept, so the formulas are
still available. Even clearing the top row will not clear the comments, as
long you do not delete the top row.

I hope I made myself clear, don't mind my English.

Jack Sons
The Netherlands

I need to know how to clear the contents of multiple cells without

deleting the formulas. I know I can do this, just can't figure it out.
Thansk!

 

[R.VENKATARAMAN]

I saw this in one of the excel tips.
try this. why not give a name to formula . it is somewaht tricky
suppose G7=E7*F7
keep the cell G7 active
use insert-name-define (or control+F3). give a name and in <refersto>window
at the bottom type <=E7*F7>
and click ok
activate anyother cell and hit F3 and the name will come up highlight the
name click ok and hit enter
the cell will be the product of previous two column cells. do some
experiments. you can even use absolute addresses or even partially absolute
addresses.

you can even copy or drag the formula

 

[Jack Sons]

Thank you.

Jack.

I saw this in one of the excel tips.
try this. why not give a name to formula . it is somewaht tricky
suppose G7=E7*F7
keep the cell G7 active
use insert-name-define (or control+F3). give a name and in