Press Ctrl+[ to go to the next-lower level precedent cells. Press Ctrl
+] to go to the next-higher level of dependent cells. Going forward
(dependents) will highlight all affected cells, similarly to how Trace
Dependents/Precedents arrow would.


Hayk wrote:
When you paste a link from one excel file to the next. Excel should have an
option to jump to the source of the data by clicking on any cell that
contains a formula link.

For example: If i have the following formula in a cell:

='[Correspondent Rates.xls]Correspondent'!$E128

Excel should allow me to jump to the file in Correspondent Rates.xls Sheet
Correspondent row/column E128 by clicking on it, instead of manually locating
the file and jumping to that row/column.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions