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