Microsoft Office Tutorials and References
In Depth Information
Navigate a Workbook Using Range Names
Navigate a Workbook
Using Range Names
One of the big advantages of defining range names is
that they make it easier to navigate a workbook. You
can choose a range name from a list and Excel
automatically selects the associated range. This
works even if the named range exists in a different
worksheet of the same workbook.
Excel offers two methods for navigating a workbook
using range names: the Name box and the Go To
command.
Navigate a Workbook Using Range Names
Using the Name Box
1 Open the workbook that
contains the range you
want to work with.
2 Click the Name box .
3 Click the name of the range
you want to select.
A Excel selects the range.
Search JabSto ::




Custom Search