1. Computing

Excel Name Box Navigation

Moving Around a Spreadsheet

By

Excel Name Box Navigation

Excel Name Box Navigation

© Ted French

Related tutorial: Excel's Go To Feature.

The Name Box in Excel can be used to quickly navigate to different cells in a spreadsheet. This article includes an example of how to use the Name Box to move to different cells.

Although not necessary for worksheets that use only a few columns and rows, for larger worksheets (remember there are over 16,000 columns and more than one million rows in a single Excel 2007 worksheet), it can be useful to have easy ways of jumping from one area to the next.

Example using Excel's Name Box for Navigation:

For help with this example, see the image above.

  1. Click on Name Box above column A to highlight the cell reference of the active cell.

  2. Type in the cell reference of the desired destination. In this case: HQ567.

  3. 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, type another cell reference in the name box and press ENTER on the keyboard.

Related Tutorials

©2014 About.com. All rights reserved.