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