SHORTCUT KEYS FOR MS EXCEL
ActionExcel 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 formattingCTRL+2
Applies or removes bold formattingCTRL+B
Applies or removes italic formattingCTRL+3
Applies or removes italic formattingCTRL+I
Applies or removes underliningCTRL+4
Applies or removes underliningCTRL+V
Applies the Currency format with two decimal placesCTRL+$
Applies the Date format with the day, month, and yearCTRL+#
Applies the Exponential number format with two decimal placesCTRL+^
Applies the General number formatCTRL+~
Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative valuesCTRL+!
Applies the outline border to the selected cellsCTRL+&
Applies the Percentage format with no decimal placesCTRL+%
Applies the Time format with the hour and minute, and AM or PMCTRL+@
Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculationCTRL+ALT+F9
Calculates all worksheets in all open workbooksF9
Calculates the active worksheetSHIFT+F9
Closes and reopens the current task paneCTRL+F1
Closes the selected workbook windowCTRL+F4
Closes the selected workbook windowCTRL+X
Copies the selected cellsCTRL+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 rangeALT+F1
Creates a chart of the data in the current rangeF11
Cuts the selected cellsCTRL+Y
Displays or hides the outline symbolsCTRL+8
Displays or hides the Standard toolbarCTRL+7
Displays the Create List dialog box. CTRL+N Creates a new, blank fileCTRL+L
Displays the Delete dialog box to delete the selected cellsCTRL+-
Displays the Find and Replace dialog boxCTRL+H
Displays the Format Cells dialog boxCTRL+1
Displays the Go To dialog boxCTRL+G
Displays the Go To dialog boxF5
Displays the Help task paneF1
Displays the Insert dialog box to insert blank cellsCTRL++
Displays the Insert Function dialog boxSHIFT+F3
Displays the Macro dialog box to run, edit, or delete a macroALT+F8
Displays the Microsoft Office ClipboardCTRL+C
Displays the Open dialog box to open or find a fileCTRL+O
Displays the Print dialog boxCTRL+R
Displays the Save As dialog boxF12
Displays the shortcut menu for a selected itemSHIFT+F10
Displays the Spelling dialog box to check spelling in the active worksheet or selected rangeF7
Edits a cell commentSHIFT+F2
Enters the current dateCTRL+;
Enters the current timeCTRL+:
Hides the selected columnsCTRL+0
Hides the selected rowsCTRL+9
Including cells not marked as needing to be calculatedCTRL+F9
Inserts a new worksheetALT+SHIFT+F1
Inserts a new worksheetSHIFT+F11
Maximizes or restores the selected workbook windowCTRL+F10
Minimizes a workbook window to an iconF10
Pastes a defined name into a formulaF3
Removes the outline border from the selected cellsCTRL+_
Repeats the last command or action, if possibleCTRL+Z
Repeats the last command or action, if possibleF4
Restores the window size of the selected workbook windowCTRL+F5
Saves the active file with its current file name and locationCTRL+S
Selects all cells that contain commentsCTRL+SHIFT+O
Selects the current regionCTRL+A
Selects the entire worksheetCTRL+A CTRL+A (two times)
Undo commandCTRL+U
Unhides any hidden columns within the selectionCTRL+