Do you want to learn the secrets of working faster in Excel? When you first start to learn how to use Excel you will probably concentrate on getting your work done rather than trying to acquire new ways of working more efficiently. However, when you are ready to discover Excel keyboard shortcuts this article shows you a treasure trove of resources supplying shortcuts for Excel 2000, 2003, 2007 and 2010.
Shortcuts give you the power to perform tasks without using the mouse to go to the Excel menu or ribbon, which means you can keep your hands on the keyboard instead of going back and forth from mouse to keyboard. With a good knowledge of Excel shortcuts you will blaze through common tasks and enhance your productivity.
For those just starting to learn shortcuts, it’s important to avoid information overwhelm. Yes there are so many shortcuts you could learn, but focus on those you’ll use most and you get the biggest benefits. Here are 3 great sites that highlight a fine selection of useful Excel Shortcuts.
For the more advanced users out there, I have hand-picked 11 links to very comprehensive Excel shortcut guides. I don’t know if there’s anyone on the planet who knows every shortcut there is to know in Excel, but the truth is that you only need to memorize the top 20% of shortcuts that will result in 80% of your personal speed gains. This all depends on what you use Excel for. Someone doing complex financial modelling will use a different set of shortcuts from someone processing invoice details. But both will benefit from knowing and using shortcuts.
4. Shortcut World (Excel 2007) – Excel 2007 Shortcuts
5. Shortcut World (Excel 2010) – Excel 2010 Shortcuts
6. Asap Utilities – Excel Keyboard Shortcuts
7. D McRitchie – Shortcut Keys in Excel 2000 through Excel 2007
8. Microsoft Office (Excel 2003) – Keyboard shortcuts in Excel 2003
9. Microsoft Office (Excel 2007) – Excel shortcut and function keys
10. Microsoft Office (Excel 2010) – Keyboard shortcuts in Excel 2010
11. Chandoo – Comprehensive List of Excel Keyboard Shortcuts
12. C Pearson – Shortcut Keys In Excel And VBA (includes downloadable workbooks)
13. Excel User – Download Charley’s Complete Excel Shortcuts Workbook (over 250 shortcuts)
14. OzGrid – Excel keyboard Shortcuts
Download my handy reference guide with more than 100 popular Excel keyboard shortcuts. It’s totally free to download, and beautifully formatted for printing – just visit our Excel Shortcuts PDF page for more details.
If I have missed any Excel shortcut links that you often use, please share them in the comments below. Also check out my article on Keyboard vs. Mouse – it talks about the different ways you can use the keyboard and mouse for maximum effectiveness.
Finally if you found these links useful please share this page using the sharing buttons below the post!
Victor expertly teaches Microsoft Excel to people all over the world. He has millions of views of his popular Excel explainer videos on YouTube. These show time-saving shortcuts and real-world applications explained with easy-to-follow visuals.
Victor has over 20 years of experience using Excel as a professional for Big 4 Audit Firm Deloitte and two global tech companies. He knows firsthand that being more productive with Excel can lead to greater job satisfaction and career growth.
Discover the PROVEN Blueprint for transforming your Excel skills, supercharging your productivity, and standing out in your career! My course helps you to learn Excel VBA and save hours of time even if you have zero prior experience with programming.
Are you looking to up your spreadsheet game? Excel is an invaluable tool that can help you stay organized and save time. From data analysis to budgets, Excel can do it all!
Today, having Excel skills is more critical than ever. Those who know how to use Excel are more likely to find higher-paying jobs. And get promoted faster.