Here's our Microsoft Office Tip for.. October 17, 2006
Click Here to see a complete list of all of our previously released Tips!
The Name Box Control
A while back, we showed you an easy way to jump to a cell--give the cell a name and then use the Name Box control. Simply select the name in the Name Box control (the drop-down control to the left of the Formula bar) and Excel will select that cell or range.

You don't have to name a cell to use the Name Box in this manner. You can also enter a cell reference, which is convenient when the cell you want to select doesn't have a name or isn't part of a named range. For instance, to jump to cell J8, you'd simply select the Name Box control. When you do, Excel will highlight the current cell's address. Enter the address of the cell you want to select, and that's all there is to it. As soon as you enter the new address, Excel will act.

If you want to select a cell on another sheet, be sure to enter the sheet name in the form

Sheetname!celladdress

For example, to select cell J8 on a sheet named Sheet3, you'd enter the address

Sheet3!J8