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
|
Monday, April 18, 2016
Top Excel Keyboard shortcuts to save yourself daily (Version: 2013):
Subscribe to:
Posts (Atom)