* Basic shortcut key for excel *
|
SHORTCUT KEYS IN EXCEL |
||
|
Ctrl+E:
- |
Full
Fill All Cell |
|
|
Ctrl+Page
Up/Down: - |
Jump
To Another Sheet |
|
|
Shift+Right/Left
Arrow: - |
Cell
Selection |
|
|
Shift+BackSpace:
- |
Row
Select |
|
|
Ctrl+Space:
- |
Column
Select |
|
|
Ctrl+Shift+Space/Ctrl+A:
- |
All
cell Select |
|
|
Ctrl+Home:
- |
Jump
To Direct First Cell |
|
|
Ctrl+End:
- |
Last
Cell |
|
|
Page
Up/Down: - |
Celling
Scroll |
|
|
Alt+Page
Up: - |
Right
Side |
|
|
Alt+Page
Down: - |
Left
Side |
|
|
Fn+f8+down
Arrow: - |
All
Cell Selection |
|
|
Ctrl+W:
- |
Close |
|
|
Ctrl+F4:
- |
Close |
|
|
Alt+Space+C:
- |
Close |
|
|
F4/Fn+F4:
- |
Last
Command Repeat |
|
|
Shift+F11/Shift+Fn+F11/Ctrl+N:
- |
New
Worksheet |
|
|
Ctrl+O:
- |
Old
File Open |
|
|
Fn+F12:
- |
Multiple
save file or document |
|
|
Ctrl+P:
- |
Print |
|
|
Fn+1:
- |
Help
in excel |
|
|
Fn+7:
- |
Spelling
checks |
|
|
Fn+F9/F9:
- |
calculate
seen the value |
|
|
Alt+V+Z:
- |
Zoom
in/Zoom Out |
|
|
Alt+F10/Alt+F10+Fn:
- |
To
View Shortcut Key in Tab |
|
|
Ctrl+F1 |
Hide/Show
Ribbon |
|
|
Ctrl+Shift+U:
- |
To
Expand Formula Bar |
|
|
Ctrl+F9:
- |
Minimize
Workbook |
|
|
F11/Fn+F11:
- |
View
Chart |
|
|
Alt+F1:
- |
View
Chart in Same Worksheet |
|
|
Alt+H:
- |
Home
Key |
|
|
Ctrl+Tab:
- |
Switch
To Another Workbook |
|
|
Shift+F3:
- |
Insert
Function |
|
|
Alt+F8:
- |
Run
Macro |
|
|
Alt+F11:
- |
VBA
(Visual Basic Application) |
|
|
Shift+Tab:
- |
Jump
To Previous Cell |
|
|
F5/Ctrl+G |
Go to
Any File |
|
|
F2+Fn:
- |
Edit
Mode |
|
|
Shift+F2:
- |
Add
Comment Cell |
|
|
Alt+Enter:
- |
Write
in Next Line of Same Cell |
|
|
Alt+H+H:
- |
To
Assign Color to cell |
|
|
Alt+H+B+A:
- |
All
Border Select |
|
|
Ctrl+Shift+&:
- |
Outline
Border |
|
|
Ctrl+Shift+___:
- |
Remove
outline Border |
|
|
Ctrl+9:
- |
Hide
Row |
|
|
Ctrl+0:
- |
Unhide
Row |
|
|
Ctrl+1:
- |
Format
Cell |
|
|
Ctrl+5:
- |
Strike-Through |
|
|
Ctrl+Shift+$:
- |
Currency
Format |
|
|
Ctrl+Shift+#:
- |
To
Apply Date Format |
|
|
Time
Format |
||
|
Ctrl+Shift+!
: - |
To
apply Number Format |
|
|
Ctrl+Shift+~:
- |
To
Apply General Format |
|
|
Ctrl+
‘: - |
Copy
From Above Cell |
|
|
Ctrl+
D: - |
Fill
Down all Cell |
|
|
Ctrl+
R: - |
Fill
Down Right Cell |
|
|
Ctrl+
F10: - |
Excel
Screen Minimize/Restore |
|
|
Ctrl+
F9: - |
Minimize
|
|
|
Ctrl+
F12: - |
Open
Dialogue Box |
|
|
Ctrl+Shift
+F1: - |
Hide
Tab and Ribbon |
|
|
Alt+
U + V: - |
Full
Screen |
|
|
Ctrl+
Shift + F3: - |
Create
Name Range |
|
|
Alt+W
+ H: - |
Wrap
text |
|
|
Ctrl+
Shift+ Page Down/Page Up: - |
Select
Multiple sheets |
|
|
Ctrl +;
: - |
Current
Date |
|
|
Ctrl+
Shift + : : - |
Current
Time |
|
|
Ctrl
+ T/ L : - |
Create
Table |
|
|
Alt +
H + O +R: - |
Change
Sheet Name |
|
|
Ctrl
+ K: - |
Hyperlink
text |
|
|
Ctrl
+ Shift + A: - |
All
Argument Seen in Excel of VLOOKUP |
|
|
Alt +
N + v: - |
Pivot
Table |
|
|
Alt +
= : - |
Auto
Sum Function |
|
|
Alt
+H + M + C: - |
Merger
and Center |
|
|
Ctrl
+ ~(Tiled): - |
Show/Hide
Formulas |
|
|
Alt +
Shift +Enter: - |
Create
Array |
|
|
Alt+
A + Q: - |
Advance
Filter |
|
|
Alt+
H +O + I: - |
Auto
Column Width |
|
Comments