Saturday, 18 August 2018

Most Important Excel Shortcut Keys | No Limit Of Study

Most Important Shortcut Keys of Excel-:

Excel Shortcut Keys

These Shorcut Keys are Very Important for MS-Excel and Excel User, Because these shortcut keys are work easy. These Shortcut keys are best Shortcut keys of Advance Excel.


S.No.

Shortcut Keys

Uses
1
Alt+O+C+AAdjust Row/Column by Text
2
Alt+O+H+RRename Sheet
3
Alt+O+H+HHide Sheet
4
Alt+O+H+UUnhide Sheet
5
Alt+D+E+EnterText to Column
6
Alt+H+S+SSort A To Z
7
Alt+H+O+HAdjust Row Height
8
Alt+E+I+SInsert Counting in Serial No.
9
Alt+H+B+AInsert All Border
10
Alt+H+B+NRemove Border
11
Ctrl+Shift+LInsert/Remove Filter
12
Alt+Any Arrow KeyOpen Filter
13
Alt+W+F+FInsert/Remove Freeze
14
Alt+N+VPivot Table
15
Alt+H+WText Wrap
16
Ctrl+SpaceSelect Column
17
Shift+SpaceSelect Row
18
Ctrl+ +Insert Column/Row
19
Ctrl+ -Remove Column/Row
20
Ctrl+Pg DnNext Sheet
21
Ctrl+Pg UpPrevious Sheet
22
Alt+V+FHide/Unhide Formula Bar
23
Ctrl+ *Select Only Sheet Data
24
Alt+ =Auto Sum
25
Alt+H+M+MMerge Cell
26
Ctrl+Shift+UOpen Formulas Bar
27
Alt+EnterUse for Enter in Cell
28
Shift+F11New Sheet
29
Ctrl+Alt+VOpen Paste Special Box

Click this link👉 Windows Shortcut Keys in Computer
Click this link👉 Fuctional (F1 to F12) Shortcut Keys
Click this link👉 Generally Shortcut Keys in Computer

1 comment:

Copyright © 2018 All Rights Reserved Nolimitofstudy