Another option as pointed out in the thread is to go Excel Options Advanced and deselect Allow editing directly in cells then when you double-click your formula in your Summary Sheet you automatically jump to the cell reference. Dependent cells can be used to show the cells that are affected by the active cells. Use Ctrl-End to jump all the way down then Home to jump to the first cell of that row and then Ctrl-Up to the last cell of the table with data.
Press the F5 key on your keyboard.
To see the cells that are dependent on the active cells follow the steps below. If youre thinking of deleting or changing a cell but dont know what it will affect Ctrl will tell you if it is used in any formulas. To see the cells that are dependent on the active cells follow the steps below. Using Hyperlink With Vlookup To Jump To A Specific Cell Excel model can be as simple as adding up two values in cell or so complicated to cover multiple sheets or even multiple workbooks.