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

4 comments:

  1. Thank you so much for such a well-written article. It’s full of insightful information. Your point of view is the best among many without fail.For certain, It is one of the best blogs in my opinion. 2ms office 2016 product key

    ReplyDelete
  2. Hi! This is my first comment here so I just wanted to give a quick shout out and say I genuinely enjoy reading your blog posts. Can you recommend any other Beauty Guest Post blogs that go over the same topics? Thanks a ton!

    ReplyDelete

Featured post

Functional Shortcut Keys in Computer | No Limit Of Study

Copyright © 2018 All Rights Reserved Nolimitofstudy