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.