Have you ever felt the need to locate the cells dependent on the cell you are editing?
When I audit my model, I need to make changes to cells. For this I have to know which cells are connected to the cell I am editing.
For example in my model, when I audit, I need to know which cells are dependent on the cell I am editing. For this I can have a look at the formula for an idea.
How can I use clear indications for showing dependant cells?
Simple I use the dependent shortcut. This function clearly shows me which cells are dependent on the selected cells using arrows !
Alt + M + D is the shortcut for dependents
How is this useful?
I can see the cells that are dependent on the cell I have selected, using clear arrows. So I know which cells change when I edit the selected cell.