Microsoft Office Tutorials and References
In Depth Information
Navigating with the Go To Dialog Box
Figure 14-7 Use the Go To dialog box to jump to a named range or to the cell or range that was
selected before the last Go To operation.
In most cases, it’s easier to use the Name box to move between named ranges. So why use
the Go To dialog box? One advantage is that it keeps track of recent cell addresses you
enter directly in the Reference box as well as the most recent cell or range. If you jump to
a table from the Go To dialog box, you can jump back to your previous selection by using
the Go To dialog box again. (This history is available only during the current session. If you
close and reopen the workbook, opening the Go To dialog box shows only named ranges
and objects.)
The Go To Special dialog box, available from the Find & Select menu or by clicking the
Special button in the Go To dialog box, offers a range of esoteric but occasionally useful
options, as shown here.
Make a selection first (or select a single cell within a table to use the entire table as the
target). Then open the Go To Special dialog box, select a category, and click OK. This option
is most useful when you want to edit, format, or otherwise work with a group of cells that
Search JabSto ::




Custom Search