■Precedents—Selects all cells to which the current selection refers. Use the Direct Only
and All Levels options to find only direct references or all references. This option is
useful when you’re trying to trace the logic of a complex worksheet by working through
a series of formulas.
■Dependents—Similar to the previous option, except it selects all cells that directly or
indirectly refer to the active cell or range.
■Last Cell—Jumps to the last cell on the worksheet that contains data or formatting.
■Visible Cells Only—Easily the most useful of all the options in the Go To Special dia-
log box. Use this ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.