Make Formulas EASIER TO READ with Visual Links!
When I double click a cell, and get a formula, ex) =M1+M2, If my CURSOR HOVERS over any one of the boxes referenced for a split second or longer, the reference in question should appear visually as a COLOURED LINE CONNECTING THE BOX BEING EDITED TO THE BOX BEING REFERENCED.
So if I'm like, Hmmm which box is M2? And I don't want to go through the labourious process of finding M2 in a forest of cells, the cell I'm editing will magically have a line in the same colour as the M2 reference within the cell appear, which connects it to the referenced cell. If the reference cell is offscreen, the line is still drawn to it, enabling me to see where it is quickly in reference to my current cell.
If you want to picture this simply, close your eyes and imagine two boxes far apart in excel, with nothing in between. Now imagine a line appearing to connect the two boxes when the box being looked at references the other box. Simple and beautiful.
Anonymous
shared this idea
Hi,
This is already supported. When you have a cell that contains a formula, you can click on the cell, then on the Formulas Ribbon, click “Trace Precedents” or “Trace Dependents.”
Excel will draw arrows for you to the cells that contribute to the cell value, or that it affects, depending on which button you click
Hope that helps,
Dan [MS]
1 comment
Comments are closed-
Anonymous
commented
Let me toggle visual links on and off. So if I'm hovering over a cell or editing a cell, and I hit a command such as shift, I should be able to see the cells it is referencing attached through it visually with lines connecting the box to the boxes being referenced,
For example: H1 is set to =A1+A2+A3. Then if I hover over or edit Cell H1 and hit the toggle switch such as SHIFT, then the H1 box should have lines connecting it to A1,A2,and A3 magically appear. Each of the 3 lines should be a different colour matching the color of the A1,A2,and A3 references in the box respectively.