MS Excel Shortcut keys List

30th, December 2013 By

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 *