Move and scroll on a worksheet or workbook by using shortcut keys:
Move and scroll on a worksheet or workbook by using shortcut keys:
The following three tables give keyboard commands available in Microsoft Excel for moving and scrolling:
In each table, the left column gives the desired action and the right column gives the associated keyboard shortcut.
| Desired Action | Keyboard Shortcut |
|---|---|
| Move one cell in a given direction. | ARROW KEY |
| Move to the edge of the current data region. | CONTROL+ARROW KEY |
| Move between unlocked cells on a protected worksheet. | TAB |
| Move to the beginning of the row. | HOME |
| Move to the beginning of the worksheet. | CONTROL+HOME |
| Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1. | CONTROL+END |
| Move down one screen. | PAGE DOWN |
| Move up one screen. | PAGE UP |
| Move one screen to the right. | ALT+PAGE DOWN |
| Move one screen to the left. | ALT+PAGE UP |
| Move to the next sheet in the workbook. | CONTROL+PAGE DOWN |
| Move to the previous sheet in the workbook. | CONTROL+PAGE UP |
| Move to the next workbook or window. | CONTROL+F6 or CONTROL+TAB |
| Move to the previous workbook or window. | CONTROL+SHIFT+F6 or CONTROL+SHIFT+TAB |
| Move to the next pane. | F6 |
| Move to the previous pane. | SHIFT+F6 |
| Scroll to display the active cell. | CONTROL+BACKSPACE |
| Desired Action | Keyboard Shortcut |
|---|---|
| Turn End mode on or off. | END |
| Move by one block of data within a row or column. | END+ARROW KEY |
| Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1. | END+HOME |
| Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command). | END+ENTER |
Tip: When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.
| Desired Action | Keyboard Shortcut |
|---|---|
| Turn SCROLL LOCK on or off. | SCROLL LOCK |
| Move to the cell in the upper-left corner of the window. | HOME |
| Move to the cell in the lower-right corner of the window. | END |
| Scroll one row up or down. | UP ARROW or DOWN ARROW |
| Scroll one column left or right. | LEFT ARROW or RIGHT ARROW |
Contact us at infotechaccess@server.rehab.uiuic.edu