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

Microsoft Excel 2003 Cell and Worksheet Navigation - Jump to the First or Last Row or Column

While navigating a Microsoft Excel 2003 worksheet, do you ever need to navigate to the first cell in a given row or the first row in a given column? Perhaps the first row or column explains more information about the numbers in a given row or column, such as that a row represents money earned in a particular day or that a given column represents a type of tax-deductible expense.

Instead of using the scroll bars or holding down the cursor keys, the following shortcuts will work:

HOME or CONTROL+LEFT ARROW - First column in the row
CONTROL+UP ARROW - First row in the column

Though not as useful except for extremely large spreadsheets, you can also use the following shortcuts to navigate:

CONTROL+RIGHT ARROW - Access column IV in the current row
CONTROL+DOWN ARROW - Access row 65,526 in the current column



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 to the First or Last Row or Column.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.