

and I am going to share it with you, NO STRINGS ATTACHED! What I was able to come up with is the most impactful piece of VBA code I've written for myself to date. Since a shortcut to flip between Excel tabs didn't seem to exist, I set out to devise a solution for my dilemma. The problem with these shortcuts is they only navigate through the order of your tabs so you would have to key them 7 times to get from tab #2 to tab #9 and at that point, you might as well grab a hold of your mouse. I searched high and low, but could only find two worksheet navigating keyboard shortcuts: Since 95% of my world consists of interacting with Excel worksheets, I was extremely upset when I couldn't find any trace of a similar shortcut to flip back and forth between two Excel tabs that I was analyzing. I also love this shortcut because every single PC user finds it useful, it is by no means a niche shortcut.

It is extremely handy when you are trying to verify information between two sources or simply trying to multitask. This simple keyboard combination lets you toggle back and forth between the current program window and the last program window you were viewing. One of my all-time favorite keyboard shortcuts is ALT + TAB.
