Computer Repair Tucson
520-272-2704
computer repair and
ccomputer networking
Desktop
Computer Repair
Laptop 
Computer Repair
How to Perform
Computer Maintenance
Short Cuts
Excel
Word
Front Page
Windows
Computer Networking
Peer-toPeer
Client Server
Excel Shortcuts
| Excel Short Cut | Short Cuts Performed |
|---|---|
| Arrow keys | Move one cell up, down, left, or right |
| CTRL+arrow key | Move to the edge of the current data region |
| HOME | Move to the beginning of the row |
| CTRL+HOME | Move to the beginning of the worksheet |
| CTRL+END | Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1 |
| PAGE DOWN | Move down one screen |
| PAGE UP | Move up one screen |
| ALT+PAGE DOWN | Move one screen to the right |
| ALT+PAGE UP | Move one screen to the left |
| CTRL+PAGE DOWN | Move to the next sheet in the workbook |
| CTRL+PAGE UP | Move to the previous sheet in the workbook |
| CTRL+F6 or CTRL+TAB | Move to the next workbook or window |
| CTRL+SHIFT+F6 or CTRL+SHIFT+TAB | Move to the previous workbook or window |
| F6 | Move to the next pane in a workbook that has been split |
| SHIFT+F6 | Move to the previous pane in a workbook that has been split |
| CTRL+BACKSPACE | Scroll to display the active cell |
| F5 | Display the Go To dialog box |
| SHIFT+F5 | Display the Find dialog box |
| SHIFT+F4 | Repeat the last Find action (same as Find Next) |
| TAB | Move between unlocked cells on a protected worksheet |
Keys for moving in a Excel worksheet with End mode on
| Excel Short Cut | Short Cuts Performed |
|---|---|
| END | Turn End mode on or off |
| END, arrow key | Move by one block of data within a row or column |
| END, HOME | Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1 |
| END, ENTER | 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) |
Keys for moving in a Excel worksheet with SCROLL LOCK on
| Excel Short Cut | Short Cuts Performed |
|---|---|
| SCROLL LOCK | Turn SCROLL LOCK on or off |
| HOME | Move to the cell in the upper-left corner of the window |
| END | Move to the cell in the lower-right corner of the window |
| UP ARROW or DOWN ARROW | Scroll one row up or down |
| LEFT ARROW or RIGHT ARROW | Scroll one column left or right |
Tip When you use 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.
Tucson Computer Networking