Solved stop link between hyphens in formula and referenced cells

April 23, 2017 at 09:01:35
Specs: Windows 10
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?


See More: stop link between hyphens in formula and referenced cells

Report •

#1
April 23, 2017 at 13:55:12
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.


Report •

#2
April 23, 2017 at 14:28:17
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...

Report •

#3
April 23, 2017 at 15:27:15
✔ Best Answer
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


Report •

Related Solutions

#4
April 23, 2017 at 15:35:15
thank you sooooo much !!! i really never thought of this !!! but it works great :) !!! that problem is definitely solved :) !!! thank you :)

Report •

Ask Question