MS Excel Shortcut keys List

30th, December 2013 By

A keyboard shortcuts are finite set of keywords that invoke any operating systems work.With the help of shortcuts we can do the work very fast and easy ways.We do not know the most of the shortcuts.

There are list of Microsoft Excel shortcuts:-

Shortcut Keys Description
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text and/or document
F11 Create chart
Ctrl + A Select all contents of worksheet
Ctrl + B Bold highlighted selection
Ctrl + C Copy selected text
Ctrl + D Fill
Ctrl + F Open find and replace options
Ctrl + G Open go-to options
Ctrl + H Open find and replace options
Ctrl + I Italicize highlighted selection
Ctrl + K Insert link
Ctrl + N Open new document
Ctrl + O Open options
Ctrl + P Open print dialog box
Ctrl + S Save
Ctrl + Y Underline selected text
Ctrl + Z Undo last action
Ctrl + Shit + ; 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 + F6 Switch between open workbooks/windows
Ctrl + F9 Minimize current window
Ctrl + F10 Maximize currently selected window
Ctrl + Tab Move between two or more open Excel files
Alt + = Create formula to sum all of above cells
Ctrl + ‘ Insert value of above cell into current cell
Ctrl + Shift + @ Format number in time format
Ctrl + Shift + ! Format number in comma format
Ctrl + Shift + # Format number in date format
Ctrl + Shift + $ Format number in currency format
Ctrl + Shift + % Format number in percentage format
Ctrl + Shift + ^ Format number in scientific format
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + Page up & Page Down Move between Excel worksheets in the same document

1 Comments on “MS Excel Shortcut keys List

Leave a Reply

Your email address will not be published. Required fields are marked *