| SHIFT +SPACE | |
| Purpose: | Use this excel shortcut key to Select the entire row. |
| CTRL +SPACE | |
| Purpose: | Use this excel shortcut key to Select the entire column. |
| CTRL +SHIFT +* (ASTERISK) | |
| Purpose: | Use this excel shortcut key to Select the current region around the active cell. |
| CTRL +A | |
| Purpose: | Use this excel shortcut key to Select the entire worksheet or the data-containing area. Pressing ctrl+a a second time then selects entire worksheet. Display Formula Window after typing formula name. |
| CTRL +SHIFT +PAGE UP | |
| Purpose: | Use this excel shortcut key to Select the current and previous sheet in a workbook. |
| CTRL +SHIFT +O | |
| Purpose: | Use this excel shortcut key to Select all cells with comments. |
| SHIFT +ARROW KEYS | |
| Purpose: | Use this excel shortcut key to Extend the selection by one cell. |
| CTRL +SHIFT +ARROW KEY | |
| Purpose: | Use this excel shortcut key to Extend the selection to the last cell with content in row or column. |
| SHIFT +PAGE DOWN /SHIFT +PAGE UP | |
| Purpose: | Use this excel shortcut key to Extend the selection down one screen /up one screen. |
| SHIFT +HOME | |
| Purpose: | Use this excel shortcut key to Extend the selection to the beginning of the row. |
| CTRL +SHIFT +HOME | |
| Purpose: | Use this excel shortcut key to Extend the selection to the beginning of the worksheet. |
| CTRL +SHIFT +END | |
| Purpose: | Use this excel shortcut key to Extend the selection to the last used cell on the worksheet (lower-right corner). |
No comments:
Post a Comment