Jumping to a Range

When your worksheets get quite large, you may want to jump right to a specific cell or named range, without the need to search for the range. Excel allows you to do this very quickly. If you want to select a named range, simply use the Name Box pull-down list (Click here to see a related figure.) to choose the named range you want selected.

You can also use the Go To dialog box. Simply press F5, and the Go To dialog box appears. (Click here to see a related figure.) Select a range in the list displayed, or enter a specific cell reference (or range reference) to which you want to jump. When you click on OK, the specified region is selected.