This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Cell and Worksheet Navigation - Jump Directly to a Given Cell

Need to jump directly to a specific cell in a Microsoft Excel 2003 worksheet and don't want to use the mouse or cursor keys?

1. Select "Edit" - "Go To" or use the keyboard shortcut CONTROL+G.

2. The "Go To" dialog box will appear. Underneath "Reference", enter the reference to the desired cell. For example, to go to the cell at row A, column 10, just enter $A$10.

To switch between worksheets, enter the worksheet name, an exclamation point, and then the rest of the cell reference. For example, to go to worksheet "Sheet 3" and focus on the cell at row J, column 22, enter Sheet3!$J$22.

3. Press ENTER or the "OK" button to jump to the desired cell.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Cell and Worksheet Navigation - Jump Directly to a Given Cell.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.