Shares the Knowledge !

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+

Last updated on: 08/10/2019


Upsc - Civils Preparation

Exam Strategy
Tips and Tricks
Preparation and Guidance
Optional Subjects - Preparation
Optional Subjects - Guidance
Many more >>

Bank Exams Preparation

Bank, Currency, Money, RBI,
Budget, Planning, Stock Exchange
Insurance, Taxation, International Organizations
Economic Issues, Fiscal Policy, Committee or Commissions
Many more >>

Computer Knowledge

History, Generations, Terminology
Hardware, Software, Internet
Networks, Shortcut Keys
Many more >>

Interview Preparation

General Do's and Don'ts in Interview
Entry and Dressing up
How to prepare?, Qualities judged
Many more >>