Excel Short Cuts
Data Entry / Fill selected cell range with current entry / CTRL + ENTER
Data Entry / Copies value from the cell above / CTRL + SHIFT + '
Data Entry / Paste selected cells rows, column / CTRL + V
Data Entry / Copies formula from the cell above / CTRL+ '
Data Entry / Fill Down / CTRL+ D
Data Entry / Fill Right / CTRL+ R
Data Entry / Enters current time / CTRL+ SHIFT + COLON
Data Entry / Complete cell entry and select below cell / ENTER
Data Entry / Cancel a cell entry / ESC
Data Entry / Positions cursor at the end of the cell contents / F2
Data Entry / Pastes defined name into a formula / F3
Data Entry / Complete cell entry and select above cell / SHIFT + ENTER
Data Entry / Complete cell entry and select left cell / SHIFT + TAB
Data Entry / Complete cell entry and select right cell / TAB
Format / Insert column / ALT + I , C
Format / Insert row / ALT + I , R
Format / Insert worksheet / ALT + SHIFT + F1
Format / Move or copy worksheet / ALT+ E, M
Format / Rename worksheet / ALT+ O, H, R
Format / Hide column / CTRL + 0
Format / Hide row / CTRL + 9
Format / Define a name / CTRL + F3
Format / Delete selected row or column / CTRL + MINUS SIGN
Format / Applies Number format / CTRL + SHIFT + 1
Format / Applies Time format / CTRL + SHIFT + 2
Format / Applies Date format / CTRL + SHIFT + 3
Format / Applies Currency format / CTRL + SHIFT + 4
Format / Applies Percentage format / CTRL + SHIFT + 5
Format / Applies Exponential number format / CTRL + SHIFT + 6
Format / Applies outline border to selected cells / CTRL + SHIFT + 7
Format / Removes outline border to selected cells / CTRL + SHIFT + MINUS SIGN
Format / Insert selected row / CTRL + SHIFT + PLUS SIGN
Format / Insert selected column / CTRL + SHIFT + PLUS SIGN
Format / Cut selected cells, rows, columns / CTRL + X
Format / Applies or removes bold formatting / CTRL+ 2
Format / Applies or removes italic formatting / CTRL+ 3
Format / Applies or removes underlining / CTRL+ 4
Format / Applies or removes strikethrough / CTRL+ 5
Format / Applies or removes bold formatting / CTRL+ B
Format / Applies or removes italic formatting / CTRL+ I
Format / Unhide selected hidden columns / CTRL+ SHIFT + 0
Format / Unhide selected hidden rows / CTRL+ SHIFT + 9
Format / Applies or removes underlining / CTRL+ U
Format / Delete comment / SHIFT + F10, M
Format / Insert worksheet / SHIFT + F11
Format / Insert or edit cell comment / SHIFT + F2
Function / Display drop down list / ALT + DOWN ARROW
Function / Delete worksheet / ALT + E, L
Function / Creates chart of data in current range / ALT + F1
Function / Opens Visual Basic (Macros) Editor / ALT + F11
Function / Displays Macro dialog box / ALT + F8
Function / Displays smart tag menu/message / ALT + SHIFT + F10
Function / Opens Microsoft Script Editor / ALT + SHIFT + F11
Function / Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation / CTRL + ALT + F9
Function / Rechecks dependent formulas and calculates all cells in all open workbooks / CTRL + ALT + SHIFT + F9
Function / Closes and reopens current task pane / CTRL + F1
Function / Close selected workbook / CTRL + F4
Function / Inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula / CTRL + SHIFT + A
Function / Create names / CTRL + SHIFT + F3
Function / Undo or Redo command to reverse or restore the last automatic correction when AutoCorrect Smart Tags are displayed / CTRL + SHIFT + Z
Function / Close selected workbook / CTRL + W
Function / Repeat last action / CTRL + Y
Function / Repeats last command or action / CTRL + Y
Function / Undo last action / CTRL + Z
Function / Displays Format Cells dialog box / CTRL+ 1
Function / Displays or hides the Standard toolbar / CTRL+ 7
Function / Displays or hides the outline symbols / CTRL+ 8
Function / Displays Microsoft Office Clipboard / CTRL+ C, C
Function / Enters current date / CTRL+ COLON
Function / Display the Windows Start menu / CTRL+ ESC
Function / Displays Find dialog box / CTRL+ F
Function / Displays Go To dialog box / CTRL+ G
Function / Displays Find/Replace dialog box / CTRL+ H
Function / Displays Insert/Edit Hyperlink dialog box / CTRL+ K
Function / Displays Create List dialog box / CTRL+ L
Function / Displays Delete dialog box / CTRL+ MINUS SIGN
Function / Creates new, blank file / CTRL+ N
Function / Displays Open dialog box / CTRL+ O
Function / Displays Print dialog box / CTRL+ P
Function / Saves active file / CTRL+ S
Function / Displays Insert dialog box / CTRL+ SHIFT + PLUS SIGN
Function / Displays Help task pane / F1
Function / Selects or closes menu bar / F10
Function / Creates chart of data in current range / F11
Function / Displays Save As dialog box / F12
Function / Repeat last action / F4
Function / Display Go To dialog box / F5
Function / Displays Spelling Check dialog box for active cell / F7
Function / Calculates all worksheets in all open workbooks / F9
Function / Calculates selected portion of formula and replaces the selected portion with the calculated value / F9 followed by ENTER (or followed by CTRL + SHIFT + ENTER for array formulas)
Function / Shortcut menu / SHIFT + F10
Function / Displays Insert Function dialog box / SHIFT + F3
Function / Repeat last Find action / SHIFT + F4
Function / Display Find dialog box / SHIFT + F5
Function / Calculates active worksheet / SHIFT + F9
Selection / Select array / CTRL + /
Selection / Select all cells directly referenced by formulas in selection / CTRL + [
Selection / Select cells that don't match formula or static value in active cell / CTRL + \
Selection / Select cells that contain formulas that directly reference active cell / CTRL + ]
Selection / Select populated cells / CTRL + A
Selection / Select all cells / CTRL + A, A
Selection / Select all cells directly or indirectly referenced by formulas in selection / CTRL + SHIFT + {
Selection / Select the cells that don't match formula or static value in active cell / CTRL + SHIFT + |
Selection / Select cells that contain formulas that directly or indirectly reference active cell / CTRL + SHIFT + }
Selection / Extend selection to last nonblank cell / CTRL + SHIFT + ARROW KEY
Selection / Extend selection to last used lower-right cell / CTRL + SHIFT + END
Selection / Extend selection to beginning of worksheet / CTRL + SHIFT + HOME
Selection / Select populated cells / CTRL + SHIFT + SPACE
Selection / Select all cells / CTRL + SHIFT + SPACE, SPACE
Selection / Select column / CTRL + SPACE
Selection / Selects current region around active cell / CTRL+ SHIFT + 8
Selection / Selects all cells that contain comments / CTRL+ SHIFT+ O
Selection / Select current and next or previous sheet / CTRL+ SHIFT+ PAGE UP, PAGE DOWN
Selection / Extend selection to last nonblank cell in the same column or row as active cell / END + SHIFT + ARROW KEY
Selection / Extend selection to last cell in current row / END + SHIFT + ENTER
Selection / Extend selection to last used cell on worksheet (lower-right corner) / END + SHIFT + HOME
Selection / Turn extend selection mode on or off / F8
Selection / Extend selection to the cell in lower-right corner of window / SCROLL LOCK + SHIFT + END
Selection / Extend selection to cell in the upper-left corner of window / SCROLL LOCK + SHIFT + HOME
Selection / Extend selection by one cell / SHIFT + ARROW KEY
Selection / Select only active cell of multiple selection / SHIFT + BACKSPACE
Selection / Add another range of cells to selection / SHIFT + F8
Selection / Extend selection to beginning of row / SHIFT + HOME
Selection / Extend selection down one screen / SHIFT + PAGE DOWN
Selection / Extend selection up one screen / SHIFT + PAGE UP
Selection / Select row / SHIFT + SPACE
View / Move one screen to left / ALT + PAGE UP
View / Switch to previous program / ALT+ SHIFT+ TAB
View / Switch next program / ALT+ TAB
View / Move one character up, down, left, or right / Arrow keys
View / Alternate between hiding and displaying objects / CTRL + 6
View / Move to edge of current data region / CTRL + ARROW KEY
View / Scroll to display active cell / CTRL + BACKSPACE
View / Move bottom most last used cell / CTRL + END
View / Maximize window size of worksheet / CTRL + F10
View / Minimize window size of worksheet / CTRL + F5
View / Switches to next workbook window / CTRL + F6
View / Moves workbook window when not maximized / CTRL + F7
View / Sizes workbook when not maximized / CTRL + F8
View / Move to beginning of worksheet / CTRL + HOME
View / Move to beginning of worksheet / CTRL + HOME
View / Switch to previous workbook window / CTRL + SHIFT + F6
View / Alternates between displaying cell values and displaying formulas in the worksheet / CTRL+ `
View / Alternates between hiding objects, displaying objects, and displaying placeholders for objects / CTRL+ 6
View / Move to next worksheet / CTRL+ PAGE DOWN
View / Move to previous worksheet / CTRL+ PAGE UP
View / Switch to next pane in split worksheet / F6
View / Move to beginning of row / HOME
View / Move down one screen / PAGE DOWN
View / Move up one screen / PAGE UP
View / Switches to previous pane in split worksheet / SHIFT + F6
F1 Displays the Excel Help task pane.
CTRL+F1 displays or hides the ribbon.
ALT+F1 creates an embedded chart of the data in the current range.
ALT+SHIFT+F1 inserts a new worksheet.
F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
SHIFT+F2 adds or edits a cell comment.
CTRL+F2 displays the print preview area on the Print tab in the Backstage view.
F3 Displays the Paste Name dialog box. Available only if there are existing names in the workbook.
SHIFT+F3 displays the Insert Function dialog box.
F4 Repeats the last command or action, if possible.
CTRL+F4 closes the selected workbook window.
ALT+F4 closes Excel.
F5 Displays the Go To dialog box.
CTRL+F5 restores the window size of the selected workbook window.
F6 Switches between the worksheet, ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the ribbon area.
SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and ribbon.
CTRL+F6 switches to the next workbook window when more than one workbook window is open.
F7 Displays the Spelling dialog box to check spelling in the active worksheet or selected range.
CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8 Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection.
SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized.
ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9 Calculates all worksheets in all open workbooks.
SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
F10 Turns key tips on or off. (Pressing ALT does the same thing.)
SHIFT+F10 displays the shortcut menu for a selected item.
ALT+SHIFT+F10 displays the menu or message for an Error Checking button.
CTRL+F10 maximizes or restores the selected workbook window.
F11 Creates a chart of the data in the current range in a separate Chart sheet.
SHIFT+F11 inserts a new worksheet.
ALT+F11 opens the Microsoft Visual Basic For Applications Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12 Displays the Save As dialog box.
Comments
Post a Comment