Microsoft Excel Keyboard Shortcut Keys
|
Shortcut Keys |
Option |
|
File (Alt + F) |
|
|
Ctrl + N |
New |
|
Ctrl + O |
Open |
|
Ctrl + S |
Save |
|
Ctrl + Shift + S |
Save As |
|
Ctrl + P |
Print |
|
Alt +F4 |
Exit |
|
Esc |
Exit Dialog |
|
Home (Alt + H) |
|
|
Ctrl + X |
Cut |
|
Ctrl + C |
Copy |
|
Ctrl + V |
Paste |
|
Ctrl + B |
Bold |
|
Ctrl + I |
Italic |
|
Ctrl +U |
Underline |
|
Ctrl + Shift + > |
Grow Font |
|
Ctrl + shift + < |
Shrink Font |
|
Ctrl + L |
Left |
|
Ctrl + E |
Centre |
|
Ctrl + R |
Right |
|
Ctrl + J |
Justify |
|
Ctrl + D |
Insert Paint Drawing |
|
F1 |
Help |
|
Ctrl + F |
Find |
|
Ctrl + H |
Replace |
|
Ctrl + A |
Select All |
|
Ctrl + = |
Subscript |
|
Ctrl + Shift + + |
Superscript |
|
Ctrl + Shift + D |
Double Under Lines |
|
Ctrl + Shift + W |
Underscore |
|
Ctrl + D |
Font |
|
Ctrl + Shift + A |
Change Text Capital Letter |
|
Ctrl + Shift + K |
Change Text Small Letter |
|
Ctrl + Z |
Undo |
|
Ctrl + Y |
Redo |
|
Ctrl + Shift + D |
Insert Current Date |
|
Ctrl + Shift + T |
Insert Current Time |
|
Ctrl + W |
Close File |
|
Alt + Backspace |
Undo |
|
Alt + F5 |
App Restore |
|
Ctrl + Shift + B |
Bold |
|
Shift + F3 |
Change Cases |
|
Ctrl + Insert |
Copy |
|
Ctrl + F10 |
Document Maximize |
|
Ctrl + F5 |
Document Restore |
|
Alt + Shift + R |
Edit |
|
Ctrl + Shift + F |
Font |
|
F5 |
Go to |
|
Ctrl + M |
Increase Indent |
|
Ctrl + Shift + M |
Decrease Indent |
|
Ctrl + Shift + N |
Normal Style |
|
Ctrl + F12 |
Open |
|
Alt + T + O |
Option Menu |
|
Ctrl + Alt + F2 |
Open |
|
Alt + Tab |
Switch Window |
|
Shift + F8 |
Select Multiple Area |
|
Ctrl + F1 |
Show / Hide Ribbon Menu |
|
Shift + F2 |
Insert Comment |
|
Editing Cells |
|
|
F2 |
Edit Cell |
|
Dell |
Delete Cell |
|
Ctrl + Shift + ; |
Insert Current Time |
|
Ctrl + ; |
Insert Current Date |
|
Alt + A + E |
Text to Column |
|
Ctrl Function Key |
|
|
Ctrl + A |
Select All |
|
Ctrl + D |
Fill Down |
|
Ctrl + R |
Fill Right |
|
Ctrl + F |
Find |
|
Ctrl + H |
Replace |
|
Ctrl + E |
Flash Fill |
|
Ctrl + F2 |
Print Preview |
|
Ctrl + F4 |
Close Window |
|
Ctrl + [ |
Go to Precedent Cell |
|
Ctrl + ] |
Go to Dependent Cell |
|
Ctrl + Space |
Select Column |
|
Ctrl + ‘ |
Color Cycle |
|
Ctrl + , |
Increase Decimal |
|
Ctrl + . |
Decrease Decimal |
|
Ctrl + F3 |
Display “Name” Box |
|
Alt Function Key |
|
|
Alt + N +V |
Insert Pivot Table |
|
Alt + D + T |
Insert A Data Table |
|
Alt + D + S |
Short A Table |
|
Alt + A + T |
Auto Filter Selection |
|
Alt + H + O + I |
Fit Column Width |
|
Alt + I + W |
Insert Worksheet |
|
Alt + H + O + R |
Change Tab Name |
|
Alt + H + O + M |
Move / Copy a Tab |
|
Alt + M + A + A |
Remove Tracing Arrows |
|
Alt + R + G |
Track Change |
|
Alt + M + V |
Evaluate Formula |
|
Alt + W + G |
Zoom to Selection |
|
Alt + M + P |
Trace Immediate Dependents |
|
Alt + W + S |
Split Screen |
|
Alt + F + T |
Excel Options |
|
Alt + I + F |
Display “Insert Function” Box |
|
Shift Function Keys |
|
|
Shift + F1 |
Reveal Formatting |
|
Shift + F2 |
Write Comment |
|
Shift + F3 |
Insert Function |
|
Shift + F4 |
Go to Action |
|
Shift + F5 |
Find and Replace |
|
Shift + F6 |
Go to Previous Frame |
|
Shift + F7 |
Choose Thesaurus Command |
|
Shift + F8 |
Shrink Selection |
|
Shift + F9 |
Add Selection |
|
Shift + F10 |
Display Shortcut Menu |
|
Shift + F11 |
Insert New Sheet |
|
Shift + F12 |
Choose Save Command |
|
Ctrl + Shift Function Key |
|
|
Ctrl + Shift + F3 |
Insert Content of Spike |
|
Ctrl + Shift + F5 |
Edit Bookmark |
|
Ctrl + Shift + F6 |
Go to Previous Window |
|
Ctrl + Shift + F7 |
Update Link |
|
Ctrl + Shift + F8 |
Extend Selection |
|
Ctrl + Shift + F9 |
Unlink Field |
|
Ctrl + Shift + F11 |
Unlock Field |
|
Ctrl + Shift + F12 |
Print Command |
|
Function Key |
|
|
F1 |
Help |
|
F9 |
Recalculate all workbooks |
|
F4 |
Anchor “Fix” Cells |
|
F5 |
Go to Command |
|
Ctrl + Shift Function Key |
|
|
Ctrl + Shift + F |
Increase Font Size |
|
Ctrl + Shift + G |
Decrease Font Size |
|
Ctrl + Shift + C |
Center Cycle |
|
Ctrl + Shift + H |
Horizontal Cycle |
|
Ctrl + Shift + V |
Vertical Cycle |
|
Ctrl + Shift + I |
Indent Cycle |
|
Ctrl + Shift + B |
Border Cycle |
|
Ctrl + Shift + 7 |
Border Outline |
|
Ctrl + Shift + - |
Border None |
|
Ctrl + Shift + 4 |
Currency cycle |
|
Ctrl + Shift + 5 |
Percent Cycle |
|
Ctrl + Shift + 6 |
Multiple Cycle |
|
Ctrl + Shift + K |
Fill Color Cycle |
|
Ctrl + Shift + S |
General Settings |
|
Ctrl + Shift + U |
Underline Cycle |
|
Ctrl + Shift + W |
Wrap Text |
|
Ctrl + Shift + Y |
Switches Cycle |
|
Ctrl + Shift + ] |
Power Trace Precedents |
|
Ctrl + Shift + [ |
Power Trace Dependents |
|
Ctrl + Shift + R |
Power Fill Right |
|
Ctrl + Alt + Shift + Function Key |
|
|
Ctrl + Alt + Shift + N |
Disable F1 Key |
|
Ctrl + Alt + Shift + P |
Print Shortcuts |
|
Ctrl + Alt + Shift + S |
Shortcut Manager |
|
Ctrl + Alt + Shift + L |
List Cycle |
|
Ctrl + Alt + Shift + , |
Go to Minimum |
|
Alt + Shift Function Key |
|
|
Alt + Shift + S |
Quick Save |
|
Alt + Shift + G |
Gridlines Toggle |
|
Alt + Shift + , |
Shift Decimal Left |
|
Alt + Shift + C |
Case Cycle |
Facebook page-
No comments:
Post a Comment