Microsoft Office Tutorials and References
In Depth Information
Navigating with your keyboard
Navigating with your keyboard
Not surprisingly, 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. Page
Up and Page Down 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.)
You can use the keyboard to scroll through the worksheet without changing the active cell by turning on Scroll Lock,
which is useful if you need to view another area of your worksheet and then quickly return to your original location.
Just press Scroll Lock and use the navigation keys to scroll through the worksheet. When you want to return to the
original position (the active cell), press Ctrl+Backspace. Then, press Scroll Lock again to turn it off. When Scroll Lock
is turned on, Excel displays Scroll Lock in the status bar at the bottom of the window.
12
The Num Lock key on your keyboard controls how the keys on the numeric keypad behave.
When Num Lock is on, the keys on your numeric keypad generate numbers. Many keyboards
have a separate set of navigation (arrow) keys located to the left of the numeric keypad.
The state of the Num Lock key doesn’t affect these keys.
Table 12.2 summarizes all the worksheet movement keys available in Excel.
TABLE 12.2 Excel Worksheet Movement Keys
Key
Action
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
Page Up
Moves the active cell up one screen
Page Down
Moves the active cell down one screen
Alt+Page Down
Moves the active cell right one screen
Alt+Page Up
Moves the active cell left one screen
Ctrl+Backspace
Scrolls the screen so that the active cell is visible
Ctrl+End
Moves the active cell to the intersection of the row with the
lowermost entry (highest row number) on the worksheet and the column
with the rightmost entry (highest column letter) on the worksheet
Continues
Search JabSto ::




Custom Search