Jumping to a Range

Summary: Need a quick way to jump to a particular part of your worksheet? You can do it by using the Go To dialog box. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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 (just above Column A) to choose the named range you want selected.

You can also use the Go To dialog box. Press F5 and the Go To dialog box appears. 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 | 2007

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.

Check out Filing Your Income Taxes Checklist today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Jumping to a Range