There are many more key combos for selecting or modifying a selection than are listed below. You can find the complete lists in Excel. Ask the Office Assistant to search for shortcut keys and then open the first topic in the list: Use shortcut keys in Microsoft Excel
More on
keyboard
shortcuts for Microsoft products
| Keys | Moves selection to: |
| TAB | Next cell to the right. |
| arrow keys | Next cell in the direction of the arrow, unless you are editing the cell. Then the arrow keys move the cursor within the cell. |
| CTRL + arrow keys | Edge of the current data region or data block (area surrounded by blank cells) |
| HOME | Beginning of the row |
| CTRL + HOME | Beginning of the worksheet |
| END | Turns on End mode in which next key pressed has a different effect. |
| CTRL + END | Last cell on worksheet, which will be in the right-most column used on the bottom-most row used. "Used" means it has data is it or it has been formatted. |
| PAGE DOWN | Down one screen. Selected cell will be in the same relative position on screen. |
| PAGE UP | Up one screen. Selected cell will be in the same relative position on screen. |
| ALT + PAGE DOWN | Right one screen. Selected cell will be in the same relative position on screen. |
| ALT + PAGE UP | Left one screen. Selected cell will be in the same relative position on screen. |
| CTRL + BACKSPACE | Scrolls to show active cell |
|
Teachers: Request permission to use this site with your class Copyright © 1997-2012 Jan Smith <jegs1@jegsworks.com>All Rights Reserved |
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~
