Tips.Net > ExcelTips Home > Data Entry > Navigation > Jumping to a Range
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.
Tip #2893 applies to Microsoft Excel versions: 97 2000 2002 2003
PivotTables Got You Perplexed? PivotTables for the Faint of Heart shows how you can start using Excel's PivotTable tool right away to spin your data into gold! You discover how easy it really is to crunch the numbers you need to crunch. Uncover the power of creating PivotTables, editing them, formatting them, customizing them, and much more.
Check out PivotTables for the Faint of Heart today!
Confused by Time?
You can put times into a worksheet, but then what? Need to do calculations with times? How about working with elapsed time? Don't be confused; learn how easy it can be. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips
Advertise on the
ExcelTips Site