MS Excel-Microsoft Excel Shortcut Keys List

Ms Excel Shortcut Keys List: MS excel shortcut keys is useful in data entry purposes and for proper storage of statistics and various calculations. There is no need to use mouse by learning these MS excel shortcut keys. These shortcut keys are easy to memorize and improve skills while using MS Excel. The usage of these shortcut keys is asked in many competitive examinations and online tests. So it is very useful to learn about the usage of these MS Excel Shortcut keys. 

The Given Below is the List of MS Excel Shortcut Keys:

  • F2: Edit the selected cell
  • F3: After a name has been created F3 will paste names
  • F5: Go to a specific cell. For example, C6
  • F7: Spell check selected text or document
  • F11: Create chart from selected data
  • Ctrl + Shift + ; : Enter the current time
  • Ctrl + ; : Enter the current date
  • Alt + Shift + F1: Insert new worksheet
  • Shift + F3: Open the Excel formula window
  • Shift + F5: Bring up search box
  • Ctrl + A: To Select all contents of the worksheet
  • Ctrl + B: Bold highlighted section
  • Ctrl + I: Italic highlighted section
  • Ctrl + K: To Insert link
  • Ctrl + U: To Underline highlighted section
  • Ctrl + 1: To Change the format of selected cells
  • Ctrl + 5: Strike through highlighted section
  • Ctrl + P: Bring up the print dialogue box to begin printing
  • Ctrl + Z: To Undo last action
  • Ctrl + F3: Open Excel Name Manager
  • Ctrl + F9: Minimize current window
  • Ctrl + F10: Maximize currently selected window
  • Ctrl + F6: Switch between open work books or windows
  • Ctrl + Page up: Move between Excel work sheets in the same Excel document
  • Ctrl + page down: Move between Excel worksheets in the same Excel document
  • Ctrl + Tab: Move between two or more open Excel document
  • Alt + =: Create a formula to sum all of the above cells
  • Ctrl + ’: Insert the value of the above cell into cell currently selected
  • Ctrl + Shift + !: Format number in comma format
  • Ctrl + Shift + $: Format number in currency format
  • Ctrl + Shift + #: Format number in date format
  • Ctrl + Shift + %: Format number in percentage format
  • Ctrl + Shift + ^: Format number in scientific format
  • Ctrl + Shift + @: Format number in time format
  • Ctrl + Arrow key: Move to the next selection on text
  • Ctrl + Space: Select entire column
  • Shift + Space: Select entire row
  • Ctrl + –: Delete the selected column or row
  • Ctrl + shift + =: Insert a new column or row
  • Ctrl + Home: Move to cell A1
  • Ctrl + ~: Switch between showing Excel formulas or their values in cells
MS Excel-Microsoft Excel Shortcut Keys List MS Excel-Microsoft Excel Shortcut Keys List Reviewed by amara sangati for Rating: 5