All Excel Keyboard Shortcuts

All Excel Keyboard Shortcuts

F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range

F12 Displays the (File > Save As) dialog box

Shift + F2 Inserts or edits a cell comment (Insert > Comment)

Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)

Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007)

Ctrl + F2 Print Preview

Ctrl + F3 Displays the (Insert > Name > Define) dialog box

Ctrl + F12 Displays the (File > Open) dialog box

Alt + F1 Creates a chart (on a chart sheet) using the highlighted range

Alt + F2 Displays the (File > Save As) dialog box

Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)

Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks

Alt + Shift + F2 Displays the (File > Save As) dialog box

Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007

Ctrl + Shift + F12 Displays the (File > Print) dialog box

Ctrl + 1 Displays the formatting dialog box

Ctrl + 2 Toggles bold on the current selection

Ctrl + 3 Toggles italics on the current selection

Ctrl + 4 Toggles underlining on the current selection

Ctrl + 5 Toggles the strikethrough of text on the current selection

Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date

Ctrl + B Toggles bold on the current selection

Ctrl + C Copies the current selection to the clipboard

Ctrl + D Copies the first cell in the selection downwards

Ctrl + F Displays the Find dialog box

Ctrl + G Displays the GoTo dialog box

Ctrl + H Displays the Replace dialog box

Ctrl + I Toggles italics on the current selection

Ctrl + K Displays the Insert Hyperlink dialog box

Ctrl + L Displays the Create Table dialog box

Ctrl + N Creates a new workbook

Ctrl + O Displays the Open dialog box

Ctrl + P Displays the Print dialog box

Ctrl + R Copies the leftmost cell in the selection to the right

Ctrl + S Saves, Displays the Save As dialog box if a new workbook

Ctrl + U Toggles underlining on the current selection

Ctrl + V Pastes the entry from the clipboard

Ctrl + W Closes the active workbook or window

Ctrl + X Cuts the current selection to the clipboard

Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action

Ctrl + Shift + F Activates the Font Tab of the format cells

Ctrl + Shift + O Selects all the cells with comments

Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells

Shift + Insert Enters the data from the clipboard

Ctrl + Tab Moves to the next open workbook or window

Alt + Tab Moves to the next application open on your computer