MS Office Excel shortcut Keys

Below  mention shortcut key which are used in Excel.

Excel shortcut Keys
F2  Edit the selected cell
F5  Go to a specific cell
F7  Spell check selected text and/or document
F11  Create chart
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  Select all contents of worksheet
Ctrl + B  Bold highlighted selection
Ctrl + I  Italicize highlighted selection
Ctrl + C  Copy selected text
Ctrl + V  Paste
Ctrl + D  Fill
Ctrl + K  Insert link
Ctrl + F  Open find and replace options
Ctrl + G  Open go-to options
Ctrl + H  Open find and replace options
Ctrl + U  Underline highlighted selection
Ctrl + Y  Underline selected text
Ctrl + 5  Strikethrough highlighted selection
Ctrl + O  Open options
Ctrl + N  Open new document
Ctrl + P  Open print dialog box
Ctrl + S  Save
Ctrl + Z  Undo last action
Ctrl + F9  Minimize current window
Ctrl + F10  Maximize currently selected window
Ctrl + F6  Switch between open workbooks/windows
Ctrl + Page up Move between Excel worksheets in the
& Page Down same document
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 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 + g  Move to next section of text
Ctrl + Space  Select entire column
Shift + Space  Select entire row
Ctrl + W  Close document

Share this