Knowing these excel shortcuts takes you a long way in saving your valuable time while working with MS Excel.
Key | Alone | Shift | Ctrl | Alt | Shift + Ctrl |
F1 | Help | What’s This Help | – | Insert Chart Sheet | – |
F2 | Edit Mode | Edit Comment | – | Save As | – |
F3 | Paste Name Formula | Paste Function | Define Name | – | Names From Labels |
F4 | Repeat Action | Find Again | Close Window | Quit Excel | – |
F5 | Goto | Find | Restore Window Size | – | – |
F6 | Next Pane | Prev Pane | Next Workbook | Switch To VBA | Prev Workbook |
F7 | Spell Check | – | Move Window | – | – |
F8 | Extend Selection | Add To Selection | Resize Window | Macro List | – |
F9 | Calculate All | Calculate Worksheet | Minimize Workbook | – | – |
F10 | Activate Menu | Context Menu | Restore Workbook | – | – |
F11 | New Chart | New Worksheet | New Macro Sheet | VB Editor | – |
F12 | Save As | Save | Open | – | |
A | – | – | Select All | – | Formula Arguments |
B | – | – | Bold | – | – |
C | – | – | Copy | – | – |
D | – | – | Fill Down | Data Menu | – |
E | – | – | – | Edit Menu | – |
F | – | – | Find | File Menu | Font Name |
G | – | – | Goto | – | – |
H | – | – | Replace | Help Menu | – |
I | – | – | Italics | Insert Menu | – |
J | – | – | – | – | – |
K | – | – | Insert Hyperlink | – | – |
L | – | – | – | – | – |
M | – | – | – | – | – |
N | – | – | New Workbook | – | – |
O | – | – | Open Workbook | Format Menu | Select Comments |
P | – | – | – | Font Size | |
Q | – | – | – | – | – |
R | – | – | Fill Right | – | – |
S | – | – | Save | – | – |
T | – | – | – | Tools Menu | – |
U | – | – | Underline | – | – |
V | – | – | Paste | – | – |
W | – | – | Close Workbook | Window Menu | – |
X | – | – | Cut | – | – |
Y | – | – | Repeat Active | – | – |
Z | – | – | Undo | – | – |
` (~) | – | – | Toggle Formula View | – | General Format |
1 (!) | – | – | Cell Format | – | Number Format |
2 (@) | – | – | Toggle Bold | – | Time Format |
3 (#) | – | – | Toggle Italics | – | Date Format |
4 ($) | – | – | Toggle Underline | – | Currency Format |
5 (%) | – | – | Toggle Strikethru | – | Percent Format |
6 (^) | – | – | Toggle between | – | Exponent Format |
7 (&) | – | – | Toggle Standard tool bar | – | Apply Border |
8 (*) | – | – | Outline | – | Select Region |
9 (() | – | – | Hide Rows | – | Unhide Rows |
0 ()) | – | – | Hide Columns | – | Unhide Columns |
– | – | – | Delete Selection | Control Menu | No Border |
= (+) | Formula | – | – | Auto Sum | Insert dialog |
[ | – | – | Direct Dependents | – | Direct Precedents |
] | – | – | All Dependents | – | All Precedents |
; (semicolon) | – | – | Insert Date | Select Visible Cells | Insert Time |
‘ (apostrophe) | – | – | – | Style | Copy Cell Value Above |
: (colon) | – | – | Insert Time | – | – |
/ | – | – | Select Array | – | Select Array |
\ | – | – | Select Differences | – | Select Unequal Cells |
Insert | Insert Mode | – | Copy | – | – |
Delete | Clear | – | Delete To End Of Line | – | – |
Home | Begin Row | – | Start Of Worksheet | – | – |
End | End Row | – | End Of Worksheet | – | – |
Page Up | Page Up | – | Previous Worksheet | Left 1 screen | – |
Page Down | Page Down | – | Next Worksheet | Right 1 screen | – |
Left Arrow | Move Left | Select Left | Move Left Area | – | – |
Right Arrow | Move Right | Select Right | Move Right Area | – | – |
Up Arrow | Move Up | Select Up | Move Up Area | – | – |
Down Arrow | Move Down | Select Down | Move Down Area | Drop down list | – |
Space Bar | Space | Select Row | Select Column | Control Box | Select All |
Tab | Move Right | Move Left | Next Window | Next Application | Previous Window |
BackSpace | – | – | Goto Active Cell | – | – |
Comments are closed.