In the Store Macro In drop down select Personal Macro Workbook.Click the Macro button drop down and select Record Macro.Creating A Personal Macro Fileįirst, if you have never triggered Excel to create a Personal Macro file you will need to do so. The following will show you step-by-step how to add the VBA code to your Personal Macro file so that you will always have this shortcut available to you while running Excel. I have named this amazingly useful piece of code: TabBack. With my proposed solution, you will be able to use the keyboard shortcut ALT+` (the acute sign is right above the TAB key on your keyboard) with Excel worksheet tabs as you would using ALT + TAB for program windows. What I was able to come up with is the most impactful piece of VBA code I've written for myself to-date.And I am going to share it with you, NO STRINGS ATTACHED! 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 multi-task. 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.
0 kommentar(er)
