Copy= Ctrl+C
Paste= Ctrl+V
Paste Value= Menu Key(key between Windows key & Ctrl.)+V
Paste Formula= Menu Key(key between Windows key & Ctrl.)+F
Paste Format= Menu Key(key between Windows key & Ctrl.)+R
Hyperlink= Ctrl+K
Find= Ctrl+F
Find Replace= Ctrl+H
Add/Remove total Filter= Alt+D+F+F
Remove Just Filter=Alt+D+F+S
Sort= Alt+D+S
Text to Column= Alt+D+E
Create Pivot Table= Alt+D+P
Open VB Editor= Alt+F11
Select Visible cells & Copy & Paste= Alt+; then Ctrl+C and then Ctrl+V
Tuesday, 17 January 2017
Excel Shortcuts
Subscribe to:
Post Comments (Atom)
-
This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support mul... -
Copy= Ctrl+C Paste= Ctrl+V Paste Value= Menu Key(key between Windows key & Ctrl.)+V Paste Formula= Menu Key(key between Windows key ...
No comments:
Post a Comment