ShortCut Keys
1.
|
Alt +
|
|
2
|
Ctrl+ Page up (together Ctrl and Page up)
|
One Page to another page
|
3
|
Ctrl+ page down
|
To the next page in excel (previous page)
|
4
|
Alt+ Tab
|
One sheet to another sheet
|
5
|
Ctrl + F
|
Fine something
|
6
|
Alt+ F4
|
Close the whole sheet
|
7
|
Window( window key) + M
|
To minimize the screen
|
8
|
Ctrl + H
|
To replace the value
|
9
|
 Ctrl+
Upper arrow |
At the Top of the excel page
|
10
|
Ctrl + Down arrow
|
At the end of the excel page
|
11
|
ALT+H B A (first press Alt then then together press HBN)
|
Apply whole border
|
12
|
Alt +H B N
|
Remove the whole border
|
13
|
Alt+ H M M
|
Merge the cell
|
14
|
Alt+ H M U
|
Unmerge the cell
|
15
|
Alt +F S
|
Increase font size
|
16
|
Alt +H W
|
Wrap the text to fit the sentence in one cell
|
17
|
Alt +H I I
|
Insert the cell
|
18
|
Ctrl + F2
|
Preview the file
|
19
|
Ctrl +F9
|
Minimize Excel sheet
|
20
|
Alt +H H
|
Fill the color in selected cell
|
21
|
Ctrl +F3
|
Define name
|
22
|
Ctrl + F5
|
Restore window size
|
23
|
Ctrl + F6
|
Next workbook window
|
24
|
Shift + F9
|
Calculate active worksheet
|
25
|
Shift +F10
|
Display shortcut menu
|
26
|
Shift + F11
|
New worksheet
|
27
|
Shift + F12
|
Save
|
28
|
Shift+ F4
|
Find Next
|
29
|
Shift+ F5
|
Find
|
30
|
Shift + F6
|
Previous pane
|
31
|
Ctrl+ A
|
Select all
|
32
|
Ctrl + B
|
Bold
|
33
|
Ctrl + G
|
Go to
|
34
|
Ctrl + D
|
Fill Down
|
35
|
Ctrl + I
|
Italic
|
36
|
Ctrl + K
|
Hyperlink
|
37
|
Ctrl+ Shift+@
|
Time format
|
38
|
Shift + F1
|
What’s this
|
39
|
Shift + F3
|
Paste function into Formula
|
40
|
Ctrl + +
|
Select the whole cell then press these two key together.
|
41
|
Ctrl + -
|
Select the whole cell then press these two key together
|
No comments:
Post a Comment