MS EXCEL SHORTKEYS


 MS EXCEL SHORTKEYS
F2 : Edit The Selected cell

F5: GoTo Specific Cell

F7: Spelling Check selected Box /Document


F11 : Create a Chart 

CTRL +Shift+; (colmn) : 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 & Page Down :  Move between Excel  worksheets in the  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

और नया पुराने