| Select Cells | |
|---|---|
| Shift+Space | Select the entire row. |
| Ctrl+Space | Select the entire column. |
| Ctrl+Shift+* (asterisk) | Select the current region around the active cell. |
| Ctrl+a (or ctrl+Shift+spacebar) | Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet. |
| Ctrl+Shift+Page Up | Select the current and previous sheet in a workbook. |
| Ctrl+Shift+o | Select all cells with comments. |
| Shift+Arrow Keys | Extend the selection by one cell. |
| Ctrl+Shift+Arrow Key | Extend the selection to the last cell with content in row or column. |
| Shift+Page Down/Shift+Page Up | Extend the selection down one screen /up one screen. |
| Shift+Home | Extend the selection to the beginning of the row. |
| Ctrl+Shift+Home | Extend the selection to the beginning of the worksheet. |
| Ctrl+Shift+End | Extend the selection to the last used cell on the worksheet (lower-right corner). |
It's gud
ReplyDelete