Top 15 Excel shortcuts for 2015.
To celebrate the end of this year, let’s look at some of the best Excel shortcuts that I have been sharing on Twitter almost every Tuesday in 2015 – #TuesdayShortcuts. Adding them to your Excel repertoire shall increase your productivity. It might be hard to remember these shortcuts, but the more shortcuts you know, the more time you will save. If you use a multiple screen set up, your time savings will even be greater, since you will save a lot of unnecessary hand movement. Still not convinced? What about health benefits? No, using shortcuts will not help you shed those unwanted pounds, but they might spare you the pain (literal pain, not an imaginary one) of this unpleasant thing called tendinitis – inflammation of your wrist’s tendon. And that mental effort of exercising your memory, shall probably help you stay mentally fit as you grow older and want to keep up with the newest features of Excel v50… You are welcome!
1. CTRL + F1 – Hide/Show Excel Ribbon
Use this shortcut whenever you need to hide Excel ribbon to automatically increase the size of your Excel working area, or bring it back up when you need it.
2. CTRL + ALT + V – Paste Special
Did you ever need to transpose your data range? Paste-Special functionality can help you with that. CTRL+ALT+V will save you multiple mouse clicks.
3. SHIFT + F3 – Bring up Insert Function dialog
Have you heard of those nifty things, called Excel functions, hit this key combination to find a function that you need.
4. CTRL + SHIFT + 7 – Draw a border around selected cells
A (much) faster way to place a border around selected range of cells.
5. CTRL + ‘ – Switch between displaying formulas and formula results.
This shortcut helps you see the formulas and functions used in your calculations.
6. ALT + = – AutoSum your cells
AutoSum – automatically sum, and then some your columns.
7. CTRL + F9 – Minimize current window.
Use with caution, when you need to hide your Excel addiction from your friends.
8. ALT + F1 – Insert a new chart
Yes, you can actually draw a chart with the help of this simple shortcut.
9. CTRL + PgDn – Cycle through worksheets left to right
Usefulness of this shortcut is directly correlated with the number of worksheets in your workbook.
10. CTRL + SHIFT + L – Turn on/off column filters
The fastest way to apply/remove a filter to your data range.
11. CTRL + 9 – Hide selected rows
Unleash your inner Houdini!
12. ALT + F11 – Open Visual Basic (VBA) Editor
Read and edit the code behind your Excel macros.
13. CTRL + T – convert active/selected range into Excel table
You haven’t used Excel, if you never used an Excel table, start now.
14. SHIFT + F10 – right mouse click
A real mouse click replacement.
15. CTRL + 1 – activate Format Cells dialog box
All of your formatting needs are at your fingertips.
Well, I could stop here, but since 2016 is almost here, let’s look at one more shortcut:
16. SHIFT + F2 – create a comment in Excel
Documenting your work is not only the best practice, but the next person stuck looking at your worksheet, will thank you.
What is your go-to Excel shortcut? Please share in the comment section.