There are many more key combos for selecting or modifying a selection than are listed below. You can find the complete lists in Excel. Open Help and search for shortcut keys and then open the topic: Keyboard shortcuts in Microsoft Excel
There are many more key combos for selecting or modifying a selection than are listed below. You can find the complete lists in Excel. Open Help and search for shortcut keys and then open the topic: Keyboard shortcuts in Microsoft Excel
| 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 (Edit mode). 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, cell A1 |
| END | Turns on End mode in which next key
pressed has a different effect from usual. END + arrow key moves selection in the direction of the arrow to the last cell with data, or to the last cell on the sheet if there are no cells with data in that direction. |
| 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 |
Last updated: September 17, 2012
