Datasheet

Table 1-1 (continued)
Keystroke Where the Cell Cursor Moves
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 Last occupied cell in the next worksheet of that workbook.
Ctrl+Page Up Last occupied cell 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.
The keystrokes that combine the Ctrl or End key with an arrow key listed in
Table 1-1 are among the most helpful for moving quickly from one edge to the
other in large tables of cell entries or in moving from table to table in a sec-
tion of the worksheet that contains many blocks of cells.
When you use Ctrl and an arrow key to move from edge to edge in a table or
between tables in a worksheet, you hold down Ctrl while you press one of the
four arrow keys (indicated by the
+ symbol in keystrokes, such as Ctrl+→).
When you use End and an arrow-key alternative, you must press and then
release the End key
before you press the arrow key (indicated by the comma
in keystrokes, such as End,
→). Pressing and releasing the End key causes the
End Mode indicator to appear on the status bar. This is your sign that Excel is
ready for you to press one of the four arrow keys.
Because you can keep the Ctrl key depressed as you press the different arrow
keys that you need to use, the Ctrl-plus-arrow-key method provides a more
fluid method for navigating blocks of cells than the End-then-arrow-key
method.
You can use the Scroll Lock key to “freeze” the position of the cell pointer in
the worksheet so that you can scroll new areas of the worksheet in view with
keystrokes such as PgUp (Page Up) and PgDn (Page Down) without changing
the cell pointer’s original position (in essence, making these keystrokes work
in the same manner as the scroll bars).
24
Part I: Getting In on the Ground Floor
05_037377 ch01.qxp 11/16/06 9:23 AM Page 24