Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

S

Samshun

Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

I am trying to create a copy of workbook with only formulas, but some cells
exist wit
=2+3 which I do Not wanted. How can I delete all of this in a single click
(Not Individualy)
 
R

RagDyer

If you wish to delete *all* numeric formulas,

=A+B
*AND*
=2+3

Try this on a copy of your sheet:

<F5> and click on "Special".
Then click on "Formulas", and make sure that
*ONLY*
"numbers" is checked.
Then <OK>.

You will see that cells containing numeric formulas are selected.
Now, just hit <Delete>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

I am trying to create a copy of workbook with only formulas, but some cells
exist wit
=2+3 which I do Not wanted. How can I delete all of this in a single click
(Not Individualy)
 
S

Samshun

Thank you. Yes I can delete all as you said, But I only need to erase cells
having formula with =2+3 Only but not =A1+B1
 
Top