Navigating in Excel

Your mouse and arrow keys are the primary navigation keys used to move from cell to cell. Unlike Word, which uses a text cursor, Excel uses a cell pointer to show you the currently active cell. The active cell accepts whatever data you enter next . As you press an arrow key, Excel moves the active cell pointer in the direction of the arrow.

Table 43.1 lists the most commonly used navigational keystrokes used within a worksheet. Use your mouse to scroll with the scrollbars. To scroll long distances, press Shift while you scroll with the mouse.

Table 43.1. Using the Keyboard to Navigate Excel

This Key	Moves to Here
Arrow keys	The direction of the arrow one cell at a time
Ctrl+Up arrow, Ctrl+Down arrow	The topmost or bottommost row with data in the worksheet
Ctrl+Left arrow, Ctrl+Right arrow	The leftmost or rightmost column with data in the worksheet
PageUp, PageDown	The previous or next screen of the worksheet
Ctrl+Home	The upper-left corner of the worksheet cell A1
End, Arrow	The last blank cell in the arrow's direction
Ctrl+PageUp, Ctrl+PageDown	Move to next or previous worksheet within current workbook