Related tutorial: Excel's Go To Feature.
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.
- 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.