Monday, April 18, 2016

Top Excel Keyboard shortcuts to save yourself daily (Version: 2013):

 
Sl.No.
Shortcut used for
Keyboard Shortcut1
Keyboard Shortcut2
1
Applying auto filter
Alt+D+F+F
Alt+A+T
2
Insert pivot table
Alt+N+V
NA
3
Align middle
Alt+H+AC
NA
4
Align Left
Alt+H+AL
NA
5
Align Right
Alt+H+AR
NA
6
Format paint
Alt+H+FP
NA
7
Autosum
Alt+=
NA
8
Merge & Center
Alt+H+M
NA
9
Insert new worksheet
Shift+F11
NA
10
Select entire column
Ctrl+Space
NA
11
Select entire Row
Shift+Space
NA
12
Navigate between worksheets
Ctrl+Pgdn or Ctrl+Pgup
NA

No comments:

Post a Comment