Excel Keyboard Shortcuts

Jump to:
Formatting Shortcuts | Navigation and Display Shortcuts | Formulas and Functions Shortcuts

Selection and Editing

[keyboard_shortcut title=”Adds other nonadjacent cells or ranges to the selection” keys=”Shift,F8″]
[keyboard_shortcut title=”Adds to the selection (toggle)” keys=”Shift,F8″]
[keyboard_shortcut title=”Cancels the editing” keys=”Esc”]
[keyboard_shortcut title=”Deletes all characters from the cursor to the end of the line” keys=”Ctrl,Delete”]
[keyboard_shortcut title=”Deletes the character to the left of the cursor” keys=”Backspace”]
[keyboard_shortcut title=”Deletes the character to the right of the cursor” keys=”Delete”]
[keyboard_shortcut title=”Open the shortcut menu” keys=”Shift,F10″]
[keyboard_shortcut title=”Edits a cell comment” keys=”Shift,F2″]
[keyboard_shortcut title=”Edits the active cell” keys=”F2″]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Copy” keys=”Ctrl,C”]

[topic topiccodes=”X7″ daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Copy” keys=”Ctrl,Insert”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Cut” keys=”Ctrl,X”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Fill Down” keys=”Ctrl,D”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Fill Right” keys=”Ctrl,R”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Find” keys=”Ctrl,F”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Paste” keys=”Ctrl,V”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Paste” keys=”Shift,Insert”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Replace” keys=”Ctrl,H”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Undo” keys=”Alt,Backspace”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Undo” keys=”Ctrl,Z”]

[topic topiccodes=”Y7″ daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting New” keys=”Ctrl,N”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Open” keys=”Ctrl,O”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Print” keys=”Ctrl,P”]
[keyboard_shortcut title=”Same as clicking the Edit Menu and selecting Save” keys=”Ctrl,S”]
[keyboard_shortcut title=”Same as clicking the Format Menu and selecting Style” keys=”Alt,'”]
[keyboard_shortcut title=”Same as clicking the Insert Menu and selecting Hyperlink” keys=”Ctrl,K”]
[keyboard_shortcut title=”Exits the program” keys=”Alt,F4″]

[keyboard_shortcut title=”Expands the selection in the direction indicated” keys=”Shift,arrow key”]
[keyboard_shortcut title=”Expands the selection to the beginning of the current row” keys=”Shift,Home”]
[keyboard_shortcut title=”Extends the selection as navigation keys are used” keys=”F8″]
[keyboard_shortcut title=”Repeats the last Find (Find Next)” keys=”Shift,F4″]

Formatting

[keyboard_shortcut title=”Adds border to outline” keys=”Ctrl,Shift,&”]
[keyboard_shortcut title=”Adds the comma format with two decimal places” keys=”Ctrl,Shift,!”]
[keyboard_shortcut title=”Adds the currency format with two decimal places” keys=”Ctrl,Shift,$”]
[keyboard_shortcut title=”Adds the date format (day, month, year)” keys=”Ctrl,Shift,#”]
[keyboard_shortcut title=”Adds the general number format” keys=”Ctrl,Shift,~”]
[keyboard_shortcut title=”Adds the percent format with no decimal places” keys=”Ctrl,Shift,%”]
[keyboard_shortcut title=”Adds the time format (hour, minute, a.m./p.m.)” keys=”Ctrl,Shift,@”]
[keyboard_shortcut title=”Sets or removes boldface” keys=”Ctrl,B”]
[keyboard_shortcut title=”Sets or removes italic” keys=”Ctrl,Insert”]
[keyboard_shortcut title=”Sets or removes strikethrough” keys=”Ctrl,5″]
[keyboard_shortcut title=”Sets or removes underlining” keys=”Ctrl,U”]
[keyboard_shortcut title=”Removes all borders” keys=”Ctrl,Shift,_”]

[topic topiccodes=”EU” daystostart=”10″ daystoend=”250″]

Navigation and Display

[keyboard_shortcut title=”Closes the window” keys=”Ctrl,F4″]
[keyboard_shortcut title=”Cycles through the ways to display objects” keys=”Ctrl,6″]
[keyboard_shortcut title=”Defines a name” keys=”Ctrl,F3″]
[keyboard_shortcut title=”Global calculation” keys=”Ctrl,Alt,F9″]
[keyboard_shortcut title=”Hides columns” keys=”Ctrl,0(zero)”]
[keyboard_shortcut title=”Hides rows” keys=”Ctrl,9″]
[keyboard_shortcut title=”Inserts a chart sheet” keys=”Alt,F1″]
[keyboard_shortcut title=”Inserts a new worksheet” keys=”Alt,Shift,F1″]
[keyboard_shortcut title=”Inserts a new worksheet” keys=”Shift,F11″]
[keyboard_shortcut title=”Opens and Displays the Creates Names dialog box” keys=”Ctrl,Shift,F3″]

[topic topiccodes=”EO” daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Opens and Displays the Find dialog box” keys=”Shift,F5″]
[keyboard_shortcut title=”Opens and Displays the Format dialog box for the selected object” keys=”Ctrl,1″]
[keyboard_shortcut title=”Opens and Displays the Go To dialog box” keys=”F5″]
[keyboard_shortcut title=”Opens and Displays the Macro dialog box” keys=”Alt,F8″]
[keyboard_shortcut title=”Opens and Displays the What’s This cursor” keys=”Shift,F1″]
[keyboard_shortcut title=”Opens and Displays Visual Basic Editor” keys=”Alt,F11″]
[keyboard_shortcut title=”Prompts Open command” keys=”Ctrl,F12″]
[keyboard_shortcut title=”Prompts Print command” keys=”Ctrl,Shift,F12″]
[keyboard_shortcut title=”Prompts Save As command” keys=”Alt,F2″]
[keyboard_shortcut title=”Prompts Save As command” keys=”F12″]

[topic topiccodes=”X7″ daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Prompts Save command” keys=”Alt,Shift,F2″]
[keyboard_shortcut title=”Prompts Spelling command” keys=”F7″]
[keyboard_shortcut title=”Makes the menu bar active” keys=”F10″]
[keyboard_shortcut title=”Maximizes or restores the workbook window” keys=”Ctrl,F10″]
[keyboard_shortcut title=”Minimizes the workbook” keys=”Ctrl,F9″]
[keyboard_shortcut title=”Moves down one screen” keys=”PgDn”]
[keyboard_shortcut title=”Moves one screen to the left” keys=”Alt,PgUp”]
[keyboard_shortcut title=”Moves one screen to the right” keys=”Alt,PgDn”]
[keyboard_shortcut title=”Moves the cell pointer left to the preceding cell in the selection” keys=”Shift,Tab”]
[keyboard_shortcut title=”Moves the cell pointer right to the next cell” keys=”Tab”]

[topic topiccodes=”Y7″ daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Moves the cell pointer to the next corner of the current cell range” keys=”Ctrl,.(period)”]
[keyboard_shortcut title=”Moves the cell pointer up to the preceding cell in the selection” keys=”Shift,Enter”]
[keyboard_shortcut title=”Moves the cursor one character in the direction of the arrow” keys=”Arrow keys”]
[keyboard_shortcut title=”Moves the cursor one word to the left” keys=”Ctrl,left arrow”]

[keyboard_shortcut title=”Moves the cursor one word to the right” keys=”Ctrl,right arrow”]
[keyboard_shortcut title=”Moves the cursor to the end of the line” keys=”End”]
[keyboard_shortcut title=”Opens and Displays Help or the Office Assistant” keys=”F1″]
[keyboard_shortcut title=”Begins editing the active cell” keys=”F2″]
[keyboard_shortcut title=”Pastes a name into a formula” keys=”F3″]
[keyboard_shortcut title=”Repeats the last action” keys=”F4″]
[keyboard_shortcut title=”Moves to the next pane” keys=”F6″]

[topic topiccodes=”EU” daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Extends the selection as navigation keys are used” keys=”F8″]
[keyboard_shortcut title=”Calculates all sheets in all open workbooks” keys=”F9″]
[keyboard_shortcut title=”Makes the menu bar active” keys=”F10″]
[keyboard_shortcut title=”Creates a chart” keys=”F11″]
[keyboard_shortcut title=”Issues Save As command” keys=”F12″]
[keyboard_shortcut title=”Moves to the beginning of the row” keys=”Home”]
[keyboard_shortcut title=”Moves to the edge of a data block” keys=”Ctrl,arrow key”]
[keyboard_shortcut title=”Moves to the first cell in the worksheet (A1)” keys=”Ctrl,Home”]
[keyboard_shortcut title=”Moves to the last active cell of the worksheet” keys=”Ctrl,End”]
[keyboard_shortcut title=”Moves to the lower-left cell displayed in the window” keys=”End*”]
[keyboard_shortcut title=”Moves to the next sheet” keys=”Ctrl,PgDn”]
[keyboard_shortcut title=”Moves to the next window” keys=”Ctrl,F6″]
[keyboard_shortcut title=”Moves to the next window” keys=”Ctrl,Tab”]
[keyboard_shortcut title=”Moves to the previous pane of a window that has been split” keys=”Shift,F6″]

[topic topiccodes=”EO” daystostart=”10″ daystoend=”250″]

[keyboard_shortcut title=”Moves to the previous sheet” keys=”Ctrl,PgUp”]
[keyboard_shortcut title=”Moves to the previous window” keys=”Ctrl,Shift,Tab”]
[keyboard_shortcut title=”Moves to the previous workbook window” keys=”Ctrl,Shift,F6″]
[keyboard_shortcut title=”Moves to the upper-left cell displayed in the window” keys=”Home*”]
[keyboard_shortcut title=”Moves up one screen” keys=”PgUp”]
[keyboard_shortcut title=”Resizes the window” keys=”Ctrl,F8″]

[keyboard_shortcut title=”Restores the window size” keys=”Ctrl,F5″]
[keyboard_shortcut title=”Scrolls left, right, up or down one cell” keys=”Arrow keys”]
[keyboard_shortcut title=”Scrolls to display the active cell” keys=”Ctrl,Backspace”]
[keyboard_shortcut title=”Selects all” keys=”Ctrl,A”]
[keyboard_shortcut title=”Selects the active cell in a range selection” keys=”Shift,Backspace”]
[keyboard_shortcut title=”Selects the block of data surrounding the active cell” keys=”Ctrl,*”]
[keyboard_shortcut title=”Selects the entire column(s) in the selected range” keys=”Ctrl,Space”]
[keyboard_shortcut title=”Selects the entire row(s) in the selected range” keys=”Shift,Space”]
[keyboard_shortcut title=”Selects the entire worksheet” keys=”Ctrl,Shift,Space”]
[keyboard_shortcut title=”Starts a new line in the current cell” keys=”Alt,Enter”]
[keyboard_shortcut title=”Toggles the display of outline symbols” keys=”Ctrl,8″]
[keyboard_shortcut title=”Toggles the display of the standard toolbar” keys=”Ctrl,7″]
[keyboard_shortcut title=”Unhides columns” keys=”Ctrl,Shift,)”]
[keyboard_shortcut title=”Unhides rows” keys=”Ctrl,Shift,(“]

Formulas and Functions

[keyboard_shortcut title=”Enters the current date” keys=”Ctrl,;”]
[keyboard_shortcut title=”Enters the current time” keys=”Ctrl,Shift,:”]
[keyboard_shortcut title=”Inserts the AutoSum formula in an empty cell” keys=”Alt,=”]
[keyboard_shortcut title=”Pastes a function into a formula” keys=”Shift,F3″]
[keyboard_shortcut title=”Prompts for a range or range name to select” keys=”Ctrl,G”]
[keyboard_shortcut title=”Automatically SUM a column” keys=”Alt,=,Enter”]