Datasheet

 Press F5 to open the Go To dialog box, type the address of the desired
cell into its Reference text box and then click OK
 Use the cursor keys as shown in Table 1-1 to move the cell cursor to the
desired cell
 Use the horizontal and vertical scroll bars at the bottom and right edge
of the Worksheet area to move the part of the worksheet that contains
the desired cell and then click the cell to put the cell cursor in it
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 and 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.
Ctrl+End or End, Home Cell in the worksheet at the intersection of the last
column that has any data in it and the last row that has
any data in it (that is, the last cell of the so-called active
area of the worksheet).
PgUp Cell one full screen up in the same column.
PgDn 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 begin-
ning of the row.
(continued)
23
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 23