Microsoft Office Tutorials and References
In Depth Information
The Go To Feature
Moving Around the
Table 14-1. Shortcut keys for moving around a worksheet
Moves one cell to the right.
Moves one cell to the left.
Moves one cell up.
Moves one cell down.
Moves up one screen. Thus, if the grid shows 10 cells at a time,
this key moves to a cell in the same column, 10 rows up (unless
you are already at the top of the worksheet).
Moves down one screen. Thus, if the grid shows 10 cells at
a time, this key moves to a cell in the same column, 10 rows
Moves to the first cell (column A) of the current row.
Moves to the first cell in the top row, which is A1.
Ctrl+End (or End, Home)
Moves to the last column of the last occupied row. This cell is at
the bottom-right edge of your data.
Excel also lets you cross great distances in a single bound using a Ctrl+arrow key
combination. These key combinations jump to the edges of your data. Edge cells
include cells that are next to other blank cells. For example, if you press Ctrl+ while
you’re inside a group of cells with information in them, you’ll skip to the right, over
all filled cells, and stop just before the next blank cell. If you press Ctrl+ again,
you’ll skip over all the nearby blank cells and land in the next cell to the right that
has information in it. If there aren’t any more cells with data on the right, you’ll wind
up on the very edge of your worksheet.
The Ctrl+arrow key combinations are useful if you have more than one table of data
in the same worksheet. For example, imagine you have two tables of data, one at the
top of a worksheet and one at the bottom. If you are at the top of the first table, you
can use Ctrl+ to jump to the bottom of the first table, skipping all the rows in
between. Press Ctrl+ again, and you leap over all the blank rows, winding up at the
beginning of the second table.
The Go To Feature
If you’re fortunate enough to know exactly where you need to go, you can use the Go
To feature to make the jump. Go To moves to the cell address you specify. It comes
in useful in extremely large spreadsheets, where just scrolling through the worksheet
takes half a day.
To bring up the Go To dialog box (shown in Figure 14-8), choose Home ➝ Editing ➝
Find & Select ➝ Go To. Or you can do yourself a favor and just press Ctrl+G. Enter
the cell address (such as C32), and then click OK.