W
Wendy
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!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron de Bruin
Hi Wendy
F5
Constants
Ok
Press the delete key
--
Regards Ron de Bruin
http://www.rondebruin.nl
F5
Constants
Ok
Press the delete key
--
Regards Ron de Bruin
http://www.rondebruin.nl
it out. Thansk!Wendy said: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
A
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Thansk!
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
deleting the formulas. I know I can do this, just can't figure it out.Wendy said:I need to know how to clear the contents of multiple cells without
Thansk!
J
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
Thansk!
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
deleting the formulas. I know I can do this, just can't figure it out.Wendy said:I need to know how to clear the contents of multiple cells without
Thansk!
J
Jack Sons
Thank you.
Jack.
Jack.
R.VENKATARAMAN said: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