In the business world, where efficiency and accuracy reign supreme, there's one tool that stands head and shoulders above the rest: Microsoft Excel. Widely regarded as the most used and most important business tool, Excel (and now Google Sheets too!) have become an indispensable tool for organizations of all sizes and industries.
Lucky for us, our Co-Founder, Shawna Martinez, is an Excel ninja and has agreed to share all of her Excel keyboard shortcuts! Below are all the combinations you need to perform tasks quickly and efficiently in 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 | Go to | 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 |
|
| Go to |
|
|
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 (^) |
|
| a |
| Exponent Format |
7 (&) |
|
| a |
| 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 |
|
| Go to Active Cell |
|
|
MTZ Solutionz: Your Excel Experts
At MTZ Solutionz, we understand the pivotal role that Excel plays in modern business operations. Our team of Excel experts are here to help you unlock the full potential of this powerful tool. Whether you need assistance with exporting data, creating custom templates, automating workflows, or developing advanced analytical models, we have the expertise and experience to meet your needs.
From small businesses to large corporations, Excel is the cornerstone of efficient business operations. With its unparalleled versatility, efficiency, and analytical capabilities, Excel continues to reign as the most vital business tool. Partner with MTZ Solutionz to harness the full power of Excel and take your business to new heights!
Comments