| (CTRL + HOME) + (CTRL + SHIFT + END) | |
| Purpose: | Use this excel shortcut key to Select entire used range of worksheet, from first to last cell |
| ALT + ; | |
| Purpose: | Use this excel shortcut key to Select visible cells |
| ALT + A TO ALT + Z | |
| Purpose: | Use this excel shortcut key to Within a dialog box: (A) Select an option; or (B) Select/clear a checkbox. (C)Specific letter is underlined in the label of the relevant option/checkbox. |
| ALT + DOWN ARROW | |
| Purpose: | Use this excel shortcut key to (A) Within cells with AutoComplete lists or AutoFilter lists, display the AutoComplete list or AutoFilter list; or (B) Within dialog boxes, expand the selected drop-down list box |
| ALT + F | |
| Purpose: | Use this excel shortcut key to Go to Backstage View |
| ALT + PAGE DOWN / ALT + PAGE UP | |
| Purpose: | Use this excel shortcut key to Go one screen to the right within active sheet / Go one screen to the left within active sheet |
| ALT + TAB | |
| Purpose: | Use this excel shortcut key to Switch windows and go to next workbook |
| ALT + UP ARROW | |
| Purpose: | Use this excel shortcut key to Close AutoComplete list |
| ARROW KEYS | |
| Purpose: | Use this excel shortcut key to (A) Within a worksheet, go to cell to the right, left, up or down of current active cell; (B) Within the Ribbon, move to the option to the next (right) or previous (left) option or tab; (C) Within a menu or sub-menu, switch between the main menu and the sub-menu; (D) Within a drop-down list, move between items; (E) Within a group of options, move between options; or (F) When Extend Selection mode is on, extend selection |
| CTRL + SHIFT + * | |
| Purpose: | Use this excel shortcut key to When in a cell, select data area around active cell |
| CTRL + . | |
| Purpose: | Use this excel shortcut key to When in a cell selection, move active cell clockwise to next corner (top-right > bottom-right > bottom-left > top-left) |
| CTRL + [ | |
| Purpose: | Use this excel shortcut key to Go to direct precedents within active worksheet |
| CTRL + ] | |
| Purpose: | Use this excel shortcut key to Go to direct dependents within active worksheet |
| CTRL + A | |
| Purpose: | Use this excel shortcut key to (A) When in a cell, select data area around active cell (press shortcut a second or third time to select entire worksheet) or select entire worksheet; or (B) When an object is selected, select all such objects in worksheet. (C)Ctrl + A is also under the Formulas and Functions category. |
| CTRL + ARROW KEYS | |
| Purpose: | Use this excel shortcut key to (A) Go to edge of current data area; or (B) Within a cell, skip a word to the left or to the right (C)Within a cell, only right and left arrows can be used |
| CTRL + BACKSPACE | |
| Purpose: | Use this excel shortcut key to Go to active cell in worksheet |
| CTRL + END | |
| Purpose: | Use this excel shortcut key to Go to last cell (cell in lowest used row and right-most used column) of worksheet (or) Within a cell, go to end of cell contents |
| CTRL + F | |
| Purpose: | Use this excel shortcut key to Display the Find and Replace dialog with the Find tab selected |
| CTRL + F6 | |
| Purpose: | Use this excel shortcut key to Alternate between current active workbook window and next workbook window |
| CTRL + G | |
| Purpose: | Use this excel shortcut key to Display the Go To dialog box |
| CTRL + H | |
| Purpose: | Use this excel shortcut key to Display the Find and Replace dialog with the Replace tab selected |
| CTRL + HOME | |
| Purpose: | Use this excel shortcut key to (A) Go to first cell of worksheet; or (B) Within a cell, go to beginning of cell contents |
| CTRL + LEFT-MOUSE-BUTTON CLICK | |
| Purpose: | Use this excel shortcut key to Add non-adjacent (A) Cells to current cell selection; or (B) Sheets to current sheet selection |
| CTRL + PAGE DOWN / CTRL + PAGE UP | |
| Purpose: | Use this excel shortcut key to Go to next sheet to the right / Go to prior sheet to the left |
| CTRL + SHIFT + { | |
| Purpose: | Use this excel shortcut key to Go to all precedents (direct and indirect) within active worksheet |
| CTRL + SHIFT + } | |
| Purpose: | Use this excel shortcut key to Go to all dependents (direct and indirect) within active worksheet |
| CTRL + SHIFT + ARROW KEYS | |
| Purpose: | Use this excel shortcut key to (A) Extend selection to edge of current data area; or (B) Within a cell, select (or add to selection) the word to the left or to the right of the current selection/insertion point Within a cell, only right and left arrows can be used. |
| CTRL + SHIFT + END | |
| Purpose: | Use this excel shortcut key to (A) Extend selection to last cell (cell in lowest used row and right-most used column) of worksheet; or (B) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the end of contents of cell or Formula Bar |
| CTRL + SHIFT + F4 | |
| Purpose: | Use this excel shortcut key to Find previous match |
| CTRL + SHIFT + HOME | |
| Purpose: | Use this excel shortcut key to (A) Extend selection to first cell of worksheet; or (B) Within a cell or the Formula Bar, select (or add to selection) all the words from the current selection/insertion point to the beginning of contents of cell or Formula Bar |
| CTRL + SHIFT + O | |
| Purpose: | Use this excel shortcut key to Go to cells with comments |
| CTRL + SHIFT + PAGE DOWN / CTRL + SHIFT + PAGE UP | |
| Purpose: | Use this excel shortcut key to Select current active and next sheet to the right / Select current active and prior sheet to the left |
| CTRL + SHIFT + TAB | |
| Purpose: | Use this excel shortcut key to (A) Go to previous workbook; or (B) Within a dialog box, go to previous tab |
| CTRL + SPACE | |
| Purpose: | Use this excel shortcut key to Select active column. Within a table: (A) First time shortcut is pressed selects active column within table; (B) Second time shortcut is pressed selects active column header (if any); and (C) Third time shortcut is pressed selects active column of worksheet |
| CTRL + TAB | |
| Purpose: | Use this excel shortcut key to (A) Go to next workbook; or (B) Within a dialog box, go to next tab |
| END | |
| Purpose: | Use this excel shortcut key to (A) Turn End mode on; (B) Within a cell, go to end of current line; (C) When Scroll Lock is turned on, go to cell in lower-right corner of the window; or (D) When a menu or sub-menu is visible, select last command of the menu or sub-menu. When End mode is on: (A) Use arrow keys to go to edge of current data area; (B) Use Home to go to last cell (cell in lowest used row and right-most used column) of worksheet; (C) Use Enter to go to last non-blank cell to the right. End mode turns off automatically after pressing arrow/Home/Enter key |
| ENTER | |
| Purpose: | Use this excel shortcut key to (A) Within Ribbon, display selected tab or execute selected command; (B) Within a dialog box, perform action for default command button in dialog box; (C) Within cell selection, move active cell to next cell (usually right or down); or (D) Within Data Form, go to first field in next record. This is also used in Data Category. |
| ESC | |
| Purpose: | Use this excel shortcut key to (A) Within menu, submenu, dialog box or message window, cancel the command and close the menu, submenu, dialog box or message window; (B) When object is selected, cancel selection |
| F1 | |
| Purpose: | Use this excel shortcut key to Display the Help Task pane |
| F5 + (ALT + S) | |
| Purpose: | Use this excel shortcut key to Display the Go To Special dialog box |
| F5 + (ALT + S) + A | |
| Purpose: | Use this excel shortcut key to Select the current array |
| F5 + (ALT + S) + B | |
| Purpose: | Use this excel shortcut key to Select all objects in worksheet |
| ALT + H + FD + P | |
| Purpose: | Use this excel shortcut key to Display/hide the Selection task pane |
| F5 + (ALT + S) + D + L | |
| Purpose: | Use this excel shortcut key to Go to all dependents |
| F5 + (ALT + S) + F | |
| Purpose: | Use this excel shortcut key to Go to cells with formulas |
| F5 + (ALT + S) + K | |
| Purpose: | Use this excel shortcut key to Go to blank cells in a sheet. |
| F5 + (ALT + S) + M | |
| Purpose: | Use this excel shortcut key to Select column differences |
| F5 + (ALT + S) + O | |
| Purpose: | Use this excel shortcut key to Go to cells with constants |
| F5 + (ALT + S) + P + L | |
| Purpose: | Use this excel shortcut key to Go to all precedents |
| F5 + (ALT + S) + T | |
| Purpose: | Use this excel shortcut key to Select cells with conditional formatting |
| F5 + (ALT + S) + T + E | |
| Purpose: | Use this excel shortcut key to Select cells with same conditional formatting |
| F5 + (ALT + S) + V | |
| Purpose: | Use this excel shortcut key to Select cells with data validation |
| F5 + (ALT + S) + V + E | |
| Purpose: | Use this excel shortcut key to Select cells with same data validation |
| F5 + (ALT + S) + W | |
| Purpose: | Use this excel shortcut key to Select row differences |
| F6 | |
| Purpose: | Use this excel shortcut key to Switch between panes in the following order: worksheet, Ribbon, Task pane, Zoom controls. |
| F8 | |
| Purpose: | Use this excel shortcut key to Turn Extend Selection mode on or off. Extend Selection mode allows you to extend the current selection using only the arrow keys. |
| HOME | |
| Purpose: | Use this excel shortcut key to (A) Used Go to beginning of a row in a worksheet; (B) Also Within a cell, go to beginning of current line; (C) When Scroll Lock is turned on, go to cell in upper-left corner of the window; or (D) When a menu or sub-menu is visible, select first command of the menu or sub-menu. |
| LEFT MOUSE BUTTON + SHIFT | |
| Purpose: | Use this excel shortcut key to Add adjacent cells or worksheets to current selection |
| PAGE DOWN / PAGE UP | |
| Purpose: | Use this excel shortcut key to Move 1 screen down / 1 screen up |
| SHIFT + ARROW KEYS | |
| Purpose: | Use this excel shortcut key to (A) Extend selection by 1 cell; or (B) Within a cell, select (or add to selection) the character to the left or to the right of the current selection/insertion point. Within a cell, you can only use right and left arrow keys. |
| SHIFT + BACKSPACE | |
| Purpose: | Use this excel shortcut key to When multiple cells are selected, select only the active cell |
| SHIFT + END | |
| Purpose: | Use this excel shortcut key to Within a cell, select to the end of the current row |
| SHIFT + F10 | |
| Purpose: | Use this excel shortcut key to Display the Context/Shortcut menu for the selected item. Equivalent to right-mouse-button click. |
| SHIFT + F4 | |
| Purpose: | Use this excel shortcut key to Repeat last find action/Find next match |
| SHIFT + F6 | |
| Purpose: | Use this excel shortcut key to Switch between panes in the following order: worksheet, Zoom controls, Task pane, Ribbon. In a split worksheet, this shortcut includes the split panes |
| SHIFT + F8 | |
| Purpose: | Use this excel shortcut key to Add non-adjacent range to current selection. Use arrow keys to move to beginning of new selection. Use Shift + Arrow keys to select new selection. |
| SHIFT + HOME | |
| Purpose: | Use this excel shortcut key to (A) Select to the beginning of the current row or (B) Within a cell, select to the beginning of the current row |
| SHIFT + PAGE DOWN / SHIFT + PAGE UP | |
| Purpose: | Use this excel shortcut key to Extend selection 1 screen down / 1 screen up |
| SHIFT + SPACE | |
| Purpose: | Use this excel shortcut key to Select active row. Also Within a table: (A) First time shortcut is pressed selects active row within table; (B) Second time shortcut is pressed selects active row of worksheet. |
| SHIFT + TAB | |
| Purpose: | Use this excel shortcut key to (A) Move one cell to the left in a worksheet or to previous unlocked cell in a protected worksheet; (B) Within a selection, move active cell to the left; (C) Within a dialog box or the Ribbon, move to previous option or option group. (D) Shift + Tab is also under the Data and Formulas and Functions categories |
| SPACEBAR | |
| Purpose: | Use this excel shortcut key to (A) Within a dialog box, perform the action that corresponds to the selected button, or select or clear a checkbox; (B) Within the Ribbon, activate the selected command or control or open the selected menu or gallery |
| TAB | |
| Purpose: | Use this excel shortcut key to (A) To Move one cell to the right in a worksheet or to next unlocked cell in a protected worksheet; (B) Within a selection, move active cell to the right; (C) Within a dialog box or the Ribbon, move to next option or option group. (D) To Complete formula and move one cell to the right in a worksheet or to next unlocked cell in a protected sheet; (E) To Select suggestion from autocomplete to complete formula and move one cell to the right or to next unlocked cell. (F) Tab is also under the Data and Formulas and Functions categories. (G) Tab is also under the Navigation and Selection and Data categories |
No comments:
Post a Comment