Microsoft Office Tutorials and References
In Depth Information
Selecting with Go To Special
the Precedents and Dependents options, first select the cell whose precedents or
dependents you want to find. When searching for precedents or dependents, Excel always
searches the entire worksheet. When you select the Precedents or Dependents option, Excel
activates the Direct Only and All Levels options:
Direct Only finds only cells that directly refer to or that directly depend on the active
All Levels locates direct precedents and dependents plus cells indirectly related to the
active cell.
Depending on the task, you might find the built-in auditing features of Excel to be just
the trick. On the Formulas tab on the ribbon, the Formula Auditing group offers the Trace
Precedents and Trace Dependents buttons. Rather than selecting all such cells, as the Go To
Special command does, clicking these buttons draws arrows showing path and direction in
relation to the selected cell.
For more information, see “Auditing and documenting worksheets” in Chapter 8.
Go To Special keyboard shortcuts
If you do a lot of “going to,” you’ll want to learn a few of these keyboard shortcuts,
which speed things up considerably:
Press Ctrl+Shift+* to select the current region.
Press Ctrl+/ to select the current array.
Press Alt+; to select the visible cells only.
Press Ctrl+[ to select the direct precedents.
Press Ctrl+Shift+{ to select all the precedents.
Press Ctrl+] to select the direct dependents.
Press Ctrl+Shift+} to select all the dependents.
Press Ctrl+\ to select row differences.
Press Ctrl+Shift+| to select column differences.
Search JabSto ::

Custom Search