EXCEL : when you type a formula in excel, all ( and ) are colored same way as the referenced cell... but: this slows down excel terribly ... !

is there a way to (temporarily) stop this linking?

I'm not sure what you are talking about. Could you please provide a little more detail?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

hello :)

as i have your email address, i will send you a printscreen of what i'm talking about :)

you will see my formula bar, and a lot of ( and ) who are colored : blue, red, ...

those colored hyphens point to the cells they refer to...

but because there are so many (my formula there is around 5000 letters long) i can almost

not type or correct in it:

i copy the formula to word and then copy it back...

re: a lot of ( and ) who are colored : blue, red, ...

those colored hyphens point to the cells they refer to...I assume that when you say "hyphen" you mean "parenthesis".

As far as I know, the coloring of the parenthesis have nothing to do with the cells they are referencing, they are merely there to keep track of each opening and closing pair of parenthesis.

As an example, enter this in the formula bar:

=(((((

You will see that each parenthesis is a different color, even though no cells have been referenced. Now, finish the "formula":

=((((()))))

You will see that the color of each closing parenthesis matches it's counterpart on the opening side. Again, no cells have been referenced, yet each pair of parenthesis is its own color.

If I now go into the pairs and start adding cell references, I don't get matching colors between the references and the parenthesis.

=(((((F5)*I8)*L9))*Q22)

The cell references themselves match the color of the cell border, but not the parenthesis.

In any case, if you think that this is slowing down Excel, then remove the = as you edit the formula and Excel will treat it as text, which should eliminate all coloring.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

thank you sooooo much !!! i really never thought of this !!! but it works great :) !!! that problem is definitely solved :) !!! thank you :)

Ask Your Question

Weekly Poll