Jumping to a Range

Summary: You can name various ranges of cells in your worksheet, which is very handy when you are putting together formulas. Excel knows that you may also want to jump to and select a named range, so it provides two quick and easy ways to accomplish the task. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2893) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.

Check out ExcelTips Premium today!