In this universe of crowded excel shortcuts, let me share with you five less-known shortcut keys of Excel which I believe a lot of you wouldn’t have used till now. I have handpicked these based on the use case from my interaction with 2,000+ classroom participants. I’m sure it will help you.
List of Shortcuts covered are:
- Ctrl + A after introducing a formula
- Shift + F3
- Ctrl + ~
- Tab
- Shift + Tab
Ctrl + A After Introducing A Formula:
Whenever you write a formula like Vlookup normally what we do, we write = Vl and press Tab so automatically it comes and we click the fx (function) button to complete the formula. Next time we won’t do this. Next time we will write = vl, press Tab and then press Ctrl + A. It automatically gives us the function argument box. And it works with all formulas.
(Picture 1)
Tab Function:
If I put = SUM, then press Ctrl + A to open function arguments box. If you put a dummy number 1 in the box, then press Tab writes 2 then press Tab 3 automatically comes.
Shift + Tab:
If I want to go to the previous box than Shift + Tab key and we can change the number. TAB key for forward and Shift + Tab key for the previous box.
Shift+ F3:
If we press Shift+ F3 than an automatically Function Argument Box opens and we can manipulate the numbers as we wish.
(Picture 2)
Ctrl + ~:
If we want to see all the formulas used in your file, then the shortcut key Ctrl + ~.
(Picture 3)
What is a back quote? We will get two different characters on the same key immediately above on TAB key. One is back Quote ` another is Tilde ~.
If we press Ctrl + ~ we can see all the formulas on the page.
I create a lot of posts around excel tips and tricks. If you have another useful excel shortcut close to your heart, comment here.
- Top 5 Quick Time-Saving Excel Shortcuts - January 16, 2016
The guys at YodaLearning also have some great online training packages you should check out.
1- http://yodalearning.com/courses/ninjaexcel/ – Designed for anyone looking to streamline analyses in Excel
2- http://yodalearning.com/courses/excel-vba-a-practical-approach – Offers you a great approach to Excel VBA
Check them out
Very cool! Love the PIP effect with Risabh speaking in the corner.
My favorite Excel shortcut is Ctrl+1 to launch the format cells box. Great way to quickly reformat data in any format desired.
I can’t thank you enough. I’m not a big Excel fan but this will patch up what I need to prseent until I get through some MATLAB code or R. Thanks a ton.