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


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

Sams Teach Yourself Office Productivity All in One
Sams Teach Yourself Office Productivity All in One (Sams Teach Yourself All in One)
ISBN: 0672325349
EAN: 2147483647
Year: 2003
Pages: 474
Authors: Greg Perry © 2008-2017.
If you may any questions please contact us: