Microsoft Excel Shortcut Keys

Action	Excel Shortcut
Alternates between displaying cell values and displaying formulas in the worksheet.	CTRL+`
Alternates between hiding objects, displaying objects, and displaying placeholders for objects.	CTRL+6
Applies or removes bold formatting	CTRL+2
Applies or removes bold formatting	CTRL+B
Applies or removes italic formatting	CTRL+3
Applies or removes italic formatting	CTRL+I
Applies or removes underlining	CTRL+4
Applies or removes underlining	CTRL+V
Applies the Currency format with two decimal places	CTRL+$
Applies the Date format with the day, month, and year	CTRL+#
Applies the Exponential number format with two decimal places	CTRL+^
Applies the General number format	CTRL+~
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values	CTRL+!
Applies the outline border to the selected cells	CTRL+&
Applies the Percentage format with no decimal places	CTRL+%
Applies the Time format with the hour and minute, and AM or PM	CTRL+@
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation	CTRL+ALT+F9
Calculates all worksheets in all open workbooks	F9
Calculates the active worksheet	SHIFT+F9
Closes and reopens the current task pane	CTRL+F1
Closes the selected workbook window	CTRL+F4
Closes the selected workbook window	CTRL+X
Copies the selected cells	CTRL+C
Copies the value from the cell above the active cell into the cell or the Formula Bar"	CTRL+"
Creates a chart of the data in the current range	ALT+F1
Creates a chart of the data in the current range	F11
Cuts the selected cells	CTRL+Y
Displays or hides the outline symbols	CTRL+8
Displays or hides the Standard toolbar	CTRL+7
Displays the Create List dialog box. CTRL+N Creates a new, blank file	CTRL+L
Displays the Delete dialog box to delete the selected cells	CTRL+-
Displays the Find and Replace dialog box	CTRL+H
Displays the Format Cells dialog box	CTRL+1
Displays the Go To dialog box	CTRL+G
Displays the Go To dialog box	F5
Displays the Help task pane	F1
Displays the Insert dialog box to insert blank cells	CTRL++
Displays the Insert Function dialog box	SHIFT+F3
Displays the Macro dialog box to run, edit, or delete a macro	ALT+F8
Displays the Microsoft Office Clipboard	CTRL+C
Displays the Open dialog box to open or find a file	CTRL+O
Displays the Print dialog box	CTRL+R
Displays the Save As dialog box	F12
Displays the shortcut menu for a selected item	SHIFT+F10
Displays the Spelling dialog box to check spelling in the active worksheet or selected range	F7
Edits a cell comment	SHIFT+F2
Enters the current date	CTRL+;
Enters the current time	CTRL+:
Hides the selected columns	CTRL+0
Hides the selected rows	CTRL+9
Including cells not marked as needing to be calculated	CTRL+F9
Inserts a new worksheet	ALT+SHIFT+F1
Inserts a new worksheet	SHIFT+F11
Maximizes or restores the selected workbook window	CTRL+F10
Minimizes a workbook window to an icon	F10
Pastes a defined name into a formula	F3
Removes the outline border from the selected cells	CTRL+_
Repeats the last command or action, if possible	CTRL+Z
Repeats the last command or action, if possible	F4
Restores the window size of the selected workbook window	CTRL+F5
Saves the active file with its current file name and location	CTRL+S
Selects all cells that contain comments	CTRL+SHIFT+O
Selects the current region	CTRL+A
Selects the entire worksheet	CTRL+A CTRL+A (two times)
Undo command	CTRL+U
Unhides any hidden columns within the selection	CTRL+