Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Cell and Worksheet Navigation

Jump to the First or Last Row or Column

Summary: Keyboard shortcut in Microsoft Excel 2003 to skip to the first or last column or row in a worksheet.

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

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Cell and Worksheet Navigation page.

Print this tip.

- Subscribe!

Search the Site: