As you probably already know, you can use the standard navigational keys on your keyboard to move around a worksheet. These keys work just as you’d expect: The down arrow moves the active cell down one row, the right arrow moves it one column to the right, and so on. PgUp and PgDn move the active cell up or down one full window. (The actual number of rows moved depends on the number of rows displayed in the window.)

The Num Lock key on your keyboard controls how the keys on the numeric keypad behave. When Num Lock is on, Excel displays Num Lock in the status bar, and the keys on your numeric keypad generate numbers.

Most keyboards have a separate set of navigational (arrow) keys located to the left of the numeric keypad. The state of the Num Lock key doesn’t affect these keys.

Table 12-4 summarizes all the worksheet movement keys available in Excel.

TABLE 12-4
Excel’s Worksheet Movement Keys

Up arrow Moves the active cell up one row
Down arrow Moves the active cell down one row
Left arrow or Shift+Tab Moves the active cell one column to the left
Right arrow or Tab Moves the active cell one column to the right
PgUp Moves the active cell up one screen
PgDn Moves the active cell down one screen
Alt+PgDn Moves the active cell right one screen
Alt+PgUp Moves the active cell left one screen
Ctrl+Backspace Scrolls the screen so that the active cell is visible
Up arrow* Scrolls the screen up one row (active cell does not change)
Down arrow* Scrolls the screen down one row (active cell does not change)
Left arrow* Scrolls the screen left one column (active cell does not change)
Right arrow* Scrolls the screen right one column (active cell does not change)

• Not Feeling Well; Here are Some Links I have contracted a cold. It's really hurt my activity the last few days. Moving anywhere is a big challenge...
• 10 Windows 7 Tips So far, Windows 7 is the bee's knees.  The more I find out, the more I like, which is saying...
• Back and other hard keys: three stories Android 2.0 introduces new behavior and support for handling hard keys such as BACK and MENU, including some special features...
• Reduce Energy Costs: Generate Your Very Own Energy Source Using Home-made Solar Cells For quite some time, solar cells appear to have been a key in making an alternative energy supply. Various international...
• Outlook for the iPhone? eWeek is reporting that a Microsoft Executive, Stephen Elop, while speaking at the Web 2.0 Expo hinted that Microsoft will...