Related article: 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:
Note: For help with this example, see the image to the right.
- Click on Name Box above column A to highlight the cell reference of the active cell.
- Type in the cell reference of the desired destination. In this case: HQ567.
- Press the ENTER key on the keyboard.
- The black box that surrounds the active cell should jump to cell HQ567 making it the new active cell.
- To move to another cell, type another cell reference in the name box and press ENTER on the keyboard.
Related Articles
