For Seniors: How to Move around an Excel Worksheet
You can move around a Microsoft Excel worksheet using the cell cursor (also called the active cell indicator). The cell cursor is the dark outline around the active cell. To change which cell is active, you can do either of the following:
With your mouse: Click the cell you want to be active.
From the keyboard: Press one of the arrow keys on the keyboard to move the cell cursor one cell at a time in the direction the arrow is pointing until you reach the cell you want to be active.
The following table provides more shortcuts for moving the cell cursor within a worksheet.
|Press This . . .||To Move . . .|
|Arrow keys||One cell in the direction of the arrow|
|Tab||One cell to the right|
|Shift+Tab||One cell to the left|
|Ctrl+any arrow key||To the edge of the current data region in a worksheet (the first or last cell that isn’t empty)|
|End||To the cell in the lower-right corner of the window(This works only when the Scroll Lock key has been pressed on your keyboard to turn on the Scroll Lock function.)|
|Ctrl+End||To the last cell in the worksheet, in the lowest used row of the rightmost used column|
|Home||To the beginning of the row containing the active cell|
|Ctrl+Home||To the beginning of the worksheet (cell A1)|
|Page Down||One screen down(The cell cursor moves, too.)|
|Alt+Page Down||One screen to the right|
|Ctrl+Page Down||To the next sheet in the workbook|
|Page Up||One screen up(The cell cursor moves, too.)|
|Alt+Page Up||One screen to the left|
|Ctrl+Page Up||To the previous sheet in the workbook|