Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Saturday, July 21, 2018

EXCEL NAVIGATION SHORTCUT KEYS

EXCEL NAVIGATION SHORTCUT KEYS

(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

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...