Thursday, 19 May 2016

Excel shortcut Key


Excel shortcut key basic

 Column1

Column2

Ctrl+C Copy
Ctrl+V Paste
Ctrl+X Cut
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+F Find
Ctrl+G Go To
Ctrl+A Select All
Ctrl+L Design Column
Ctrl+K Hyperlink
Ctrl+H Replace
Ctrl+D Copy to upper cell text
Ctrl+S Save
Ctrl+N New Excel Open
Ctrl+B Bold
Ctrl+O Open
Ctrl+I Italic
Ctrl+U Underline
Ctrl+T Creat Table
Ctrl+W Close Document
Ctrl+; Current Date
Ctrl+Shift+< Copy to upper cell text
Ctrl+Shift+F Formate Cell window
Ctrl+Shift+: Current Time
Excel shortcut key basic Expend to Formula Bar
Ctrl+Alt+V Paset Special
Ctrl+Alt+Q æ
Alt+N Go Insert Tab
Alt+M Go Formulas Tab
Alt+A Go Data Tab
Alt+W Go View Tab
Alt+R Go Review Tab
Alt+P Go Page layout
Ctrl+( Hide to Raw
Ctrl+) Hide to Colum
Ctrl+Shift+& Boder to selected colums 
Ctrl+Alt+$

No comments: