1. Computing

Excel's Go To Feature

An Excel Keyboard Shortcut

By

Using Excel's Go To Feature

Using Excel's Go To Feature

© Ted French

Related tutorial: Excel Name Box Navigation.

The Go To feature in Excel can be used to quickly navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells using a keyboard shortcut.

Although not necessary for worksheets that use only a few columns and rows, for larger worksheets it can be useful to have easy ways of jumping from one area of your worksheet to another.

To activate the Go To feature using the keyboard, press the F5 key

Example using Excel's Go To feature for Navigation:

  1. Press the F5 key on the keyboard to bring up the Go To dialog box.

  2. Type in the cell reference of the desired destination in the Reference line of the dialog box. In this case: HQ567.

  3. Click on the OK button or press the ENTER key on the keyboard.

  4. The black box that surrounds the active cell should jump to cell HQ567 making it the new active cell.

  5. To move to another cell, repeat steps 1 to 3.

Related Tutorials

©2014 About.com. All rights reserved.