Ms-Excel Short-Cut-Key
No.
|
Press key
|
Use of command
|
👉
|
Home Tab Shortcuts Keys
|
👇👇
|
1.
|
Decrease Indent
|
Ctrl + Alt + Shift + Tab
|
2.
|
Increase Indent
|
Ctrl + Alt + Tab
|
3.
|
Percent Style
|
Ctrl + Shift + %
|
4.
|
Date Insert
|
Ctrl + ;
|
5.
|
Time Insert
|
Ctrl + Shift + :
|
6.
|
Hide Rows
|
Ctrl + 9
|
7.
|
Hide Columns
|
Ctrl + 0
|
8.
|
UnHide Rows
|
Ctrl + Shift + (
|
9.
|
UnHide Columns
|
Ctrl + Shift + )
|
10.
|
Auto Sum
|
Alt + =
|
11.
|
Down
|
Ctrl + D
|
12.
|
Right
|
Ctrl + R
|
13.
|
Filter
|
Ctrl + Shift + L
|
14.
|
Go To
|
Ctrl + G
|
15.
|
Check Total Row
|
Ctrl + Down Arrow
|
👉
|
Insert Tab Shortcuts Keys
|
👇👇
|
16.
|
Insert Function
|
Shift + F3
|
17.
|
Name Manager
|
Ctrl + F3
|
18.
|
Create From Selection
|
Ctrl + Shift + F3
|
19.
|
Show Formulas
|
Ctrl + `
|
0 Comments:
Post a Comment