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 + ~
- 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.
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.
If we press Shift+ F3 than an automatically Function Argument Box opens and we can manipulate the numbers as we wish.
Ctrl + ~:
If we want to see all the formulas used in your file, then the shortcut key Ctrl + ~.
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.