Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
Keystroke shortcuts for moving the cell cursor
Excel offers a wide variety of keystrokes for moving the cell cursor to a
new cell. When you use one of these keystrokes, the program automatically
scrolls a new part of the worksheet into view, if this is required to move the
cell pointer. In Table 1-1, I summarize these keystrokes, including how far
each one moves the cell pointer from its starting position.
Table 1-1
Keystrokes for Moving the Cell Cursor
Keystroke
Where the Cell Cursor Moves
or Tab
Cell to the immediate right.
or Shift+Tab
Cell to the immediate left.
Cell up one row.
Cell down one row.
Home
Cell in Column A of the current row.
Ctrl+Home
First cell (A1) of the worksheet.
Cell in the worksheet at the intersection of the last column
that has data in it and the last row that has data in it (that is,
the last cell of the so-called active area of the worksheet).
Page Up Cell one full screen up in the same column.
Page Down Cell one full screen down in the same column.
Ctrl+ or End, First occupied cell to the right in the same row that is either
preceded or followed by a blank cell. If no cell is occupied,
the pointer goes to the cell at the very end of the row.
Ctrl+ or End, First occupied cell to the left in the same row that is either
preceded or followed by a blank cell. If no cell is occupied,
the pointer goes to the cell at the very beginning of the row.
Ctrl+ or End, First occupied cell above in the same column that is either
preceded or followed by a blank cell. If no cell is occupied,
the pointer goes to the cell at the very top of the column.
Ctrl+ or End, First occupied cell below in the same column that is either
preceded or followed by a blank cell. If no cell is occupied,
the pointer goes to the cell at the very bottom of the column.
Ctrl+Page Down The cell pointer’s location in the next worksheet of that
workbook.
Ctrl+Page Up The cell pointer’s location in the previous worksheet of
that workbook.
Note: In the case of those keystrokes that use arrow keys, you must either use the arrows on the
cursor keypad or else have the Num Lock disengaged on the numeric keypad of your keyboard.
Ctrl+End or End,
Home
Search JabSto ::




Custom Search